Xtremer360 Posted September 30, 2010 Share Posted September 30, 2010 So I filled out my edit form and I had it echo the query and it said exactly what it was supposed to but it didn't update it. Here's what the echo query looked like. UPDATE `efed_list_menu_items` SET `content_id`='0', `newscat`='0', `application_id`='1', `itemname`='Testing 3', `itemurl`='testing3.php', `sortorder`='3' WHERE `id` = '3' Quote Link to comment https://forums.phpfreaks.com/topic/214849-echoed-query-didnt-update/ Share on other sites More sharing options...
Pikachu2000 Posted September 30, 2010 Share Posted September 30, 2010 Are you reporting errors in the script? And what happens if you copy/paste the query into phpMyAdmin? Does it work there? Quote Link to comment https://forums.phpfreaks.com/topic/214849-echoed-query-didnt-update/#findComment-1117695 Share on other sites More sharing options...
harristweed Posted September 30, 2010 Share Posted September 30, 2010 I would guess that the problem is the ` change to straight ones! Quote Link to comment https://forums.phpfreaks.com/topic/214849-echoed-query-didnt-update/#findComment-1117696 Share on other sites More sharing options...
Pikachu2000 Posted September 30, 2010 Share Posted September 30, 2010 I would guess that the problem is the ` change to straight ones! Backticks, as above, can be used to enclose table/field names in a MySQL query. They are required when the table/field name is also a MySQL reserved word. Single-quotes are used to enclose string values. Quote Link to comment https://forums.phpfreaks.com/topic/214849-echoed-query-didnt-update/#findComment-1117697 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.