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' 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? 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! 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. Link to comment https://forums.phpfreaks.com/topic/214849-echoed-query-didnt-update/#findComment-1117697 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.