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? :blink: