how to display ref name after user click the link? – Phpmyadmin
lets say I have the link http://localhost:8080/Simple/index.php?ref=user5 after I click it, I want "user5" to show up inside Input. Thank you in advance
Using insert query CI PHP Mysql Ajax – Phpmyadmin
Iam new on using Code Igniter. I want to use a custom insert query, reason is i want to use uuid() on my query and Im not sure what part of my code is wrong. I echoed the query, it…
Syntax Procedure Mysql – Phpmyadmin
I'm trying to create a stored procedure in phpmyadmin but when I try to create a second one, I get the error #1327 - Undeclared variable. This works fine: BEGIN DECLARE id_pro INT(9); SELECT user_product_id INTO id_pro FROM usuario; END…
How do I set trigger to copy user_id to another table – Phpmyadmin
I need a trigger in phpmyadmin for 2 tables. I have two tables called users and group_has_users. Table group_has_users has 2 values called group_id and user_id. I'm trying to make a trigger that automatically inserts new data to group_has_users table…
Class Mailchimp does not exist – Magento
I've just added the MailChimp extension in Magento 2.2.5. But there is a configuration error occurring. When I click on the configuration of MailChimp it doesn't show anything and store configuration throwing an error message "Class Mailchimp does not exist"…
How can I remove all the duplicate rows including the original one in SQL? – Phpmyadmin
I have a table like this: id id2 1 435 2 345 3 345 4 567 5 456 6 987 7 987 Here in id2 345 and 987 are repeating twice, so I want to delete both the rows. My…
remove unwanted characters from the beginning of titles – Phpmyadmin
table arts column title - example: 1122 A TITLE 025 - ANOTHER TITLE 1/7 - SOME TITLE 1 4 5 - SOME ANOTHER TITLE I need to remove everything before the real title. Characters for removing are - everything except…
SQL for WP to delete users with multiple meta keys and comments – Phpmyadmin
I need help putting together an SQL that can to remove users if they don't have (metakey1 or metakey2) and (does not have comments) I have this SQL which does it for single meta_key SELECT * FROM wp_users LEFT JOIN…
How to empty a table without having DROP/TRUNCATE command privilege? – CPanel
I am getting this error. My client said there is no option to give me those privileges. It's a very restricted cPanel or something. So I need to find a way to empty the table, and also reset the incremental…
How can I delete duplicate (mixture of two rows) rows in SQL? – Phpmyadmin
I have a table like this: id c1 c2 1 5 abc 2 5 abc 3 2 xyz 4 2 xyz 5 68 sdf I want to remove rows where c1 & c2 are same (that is row with id…