Sarah asked 5 years ago
Hello, I appreciate your framework very much.
$g->table =”wp_users”; works fine and I can edit all.
$g->select_command = “SELECT * FROM wp_users WHERE ID = 17”; does not work.
It shows the row correctly. When I try to edit the email for example the following error occurs:
“Couldn’t execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘SET `user_login`=’Tester03′,`user_pass`=’$P$BzrktcAX1ZwDVolmyOzT993lGyCtOz/’,`us’ at line 1 – UPDATE SET `user_login`=’Tester03′,`user_pass`=’$P$BzrktcAX1ZwDVolmyOzT993lGyCtOz/’,`user_nicename`=’tester03′,`user_email`=’[email protected],`user_url`=”,`user_registered`=’2019-08-12 14:04:30′,`user_activation_key`=”,`user_status`=’0′,`display_name`=’Tester03′ WHERE `ID` IN (’17’)”
What am I doing wrong? I also tried to set the user id in quotes ..
Abu answered 5 years ago
You just need to set table as well when using sql_command.
See query has missing table name in update query.
