Advertisements Hello this my first time on Stack Overflow and i am a begginer in php and phpMyAdmin. I have an error that i can’t understand. I have a search bar with a redirect button. I can succesfully search a product by writing "cere" (cereal in my database). Clicking the button will give me every… Read More Why can I not select the description of a product in my database?
Advertisements I have a database table with the name dt_account data and the structure is more or less like this : and a transaction table with the name dt_jurnaltransaksi and a structure like this : This is the result of querying the table above with the child parent tree, and this is what happens in… Read More PHP Mysql Sum children and acumulate with parents tree
Advertisements I am making a sql query to show me the following: 1.- Results that have "_go_product_url" in the meta_key and that is not null. 2.- And I need it to only show me in the results based on the first query that do not have the meta_key "_go_product_info" What would be the best method… Read More SQL Querry that does not exist Phpmyadmin
Advertisements id name updated_at desc_id 1 Bananas 2021-12-06 09:58:59 2 2 Melons 2022-01-10 10:08:57 1 3 Pies 2019-11-07 11:20:48 3 I need to create the column desc_id that takes informations from updated_at and gives back ids in descending order from the oldes to the newest. I have so little information of mysql that i don’t… Read More How to create a column of mysql using another column (answered)
Advertisements basically I’m making a page where the information from mySQL database will be displayed. I have a column named topics in the database where the string (VARCHAR) goes like this: Marketing, Business, Law, Medicine, … I’m trying to break up this string after a comma and display them in a single line one by… Read More Split a comma delimited string into an array and display on html page
Advertisements I’m trying to use the existing values in columns to create a new column using phpmyadmin. I currently have the following database. | First_Name | Second_Name | Full_Name | | ———- | ————– | ——— | | Paul | Smith | | | Mike | Wazowski | | … I have first names and… Read More phpmyadmin combine text and column in SET SQL
Advertisements I am attempting to prepare my sql statement however I am getting an error thrown that I cannot discern. Uncaught Error: Call to a member function fetch_assoc() on bool I have this error reporting on at the top of my file: ini_set(‘display_errors’, ‘1’); ini_set(‘display_startup_errors’, ‘1’); error_reporting(E_ALL); mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); Section that fails: $alreadyHasJob =… Read More mysqli prepared statement throwing uncaught error
Advertisements Sorry if my English is bad: I’m French ^^ I want insert that but I can’t because I have an error CREATE TABLE IF NOT EXISTS `moneysafes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `safe` varchar(50) NOT NULL DEFAULT ‘0’, `money` int(11) NOT NULL DEFAULT 0, `transactions` text NOT NULL DEFAULT ‘0’, PRIMARY KEY (`id`)… Read More I have a problem when I want to insert a sql text in my phpmyadmin
Advertisements I have a CRUD project based on react and nodejs. when I try to index.js, I recieve the following error: Named export ‘express’ not found ( please open the image to see the error) The index.js code is the following import express from "express" ; import cors from "cors" ; import UserRoute from "./routes/UserRoute.js"… Read More SyntaxError: Named export 'express' not found
Advertisements This is the results table: student_id | subject_id | get_ca1 | get_ca2 | get_exam | get_total ———————————————————————- 101 | 1 | 10 | 7 | 10 | 102 | 2 | 5 | 5 | 10 | 103 | 1 | 9 | 10 | 4 | 101 | 1 | 8 | 10… Read More SQL: set trigger to get the sum of rows