Hello,
I am getting the following message on my checkout_success page:
==========================
1064 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 'LIMIT 1' at line 5
in:
[UPDATE orders SET dropdown = '', gift_message = '' WHERE orders_id = LIMIT 1]
==========================
So I opened class.drop_down.php and I am not sure how I should change this code to fix the SQL error:
===================
// get the value of the selected dropdown
$dropdown = zen_db_input($_SESSION['dropdown']);
$gift_message = zen_db_input($_SESSION['gift-message']);
// add selected dropdown option to the orders table
$db->Execute("UPDATE " . TABLE_ORDERS . "
SET dropdown = '" . $dropdown . "',
gift_message = '" . $gift_message . "'
WHERE orders_id = " . $orders_id . "
LIMIT 1");
// unset the dropdown session
unset($_SESSION['dropdown']);
unset($_SESSION['gift-message']);
===================
Please can someone help?![]()



