In PhpMyAdmin I can use the following script and it works like charm: SELECT personal.city, GROUP_CONCAT(technologies.tech) FROM personal INNER JOIN technologies ON technologies.uid = personal.uid WHERE personal.uid = 88 But I have a dynamic method, which looks like this: public…
I am trying to create a login in SQL and using stored procedures to capture the login information. Even when executing the stored procedure on phpmyadmin, my out param is always returning Null, and I can't figure out why. userid…
I want to have 5 random reviews appear on my home page each time someone visits. I found some code to fetch all the reviews: //add get product reviews to homepage function get_woo_reviews() { $count = 0; $html_r = "";…
I have faced a problem. I need to get a specific product purchase date using the user id and product id. Using "Checking if customer has already bought something in WooCommerce" answer code, it checks all product in the following:…
I have a database containing different information from our website. One table (called Raw_Pages) contains a list of every page on our site and the path to it (along with other fields of course). Another table (called Paths) contains a…
I am using phpMyAdmin on MySQL 5.7 The code below selects the lowest values excluding any zero values and gives me a nice table of all the teamids with the lowest times in seconds next to them for that event…
How to display the information of the customer who has the most 'use' in 'audit' table. problem i dont know how to get information customer. select * from audit where used= (select MAX(used) from audit) audit table customer table
I am looking to remove the last 30 characters from a colum within my database. Column Name = gatewayid Table Name = tblclients I have created the below which works in the sense it shows me the result and it's…
actually i had some text content to include into my database the format is text. But i can save it in my database (in phpmyadmin)i'm using xammp . Can you help me to find where is the problem with my…
I am using mysql and here is the schema that I have. First table: Keywords +------------+-------------+ | keyword_id | keyword_tag | +------------+-------------+ | 2 | marketing | | 58 | sales | | 59 | scraping | | 1 |…