Code: Select all
$query="INSERT INTO order_complete (id,order_id,shipping_info,billing_info,email,status,order,total)" . " VALUES ('NULL', '$sid', '$shipping_info','$billing_info','$email_code','new','$cart_main_output2','$session_order_amount')";
mysql_query($query) or die(mysql_error());so what could cause this error? the table order is the exact same as well... thank you so muchYou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order,total) VALUES ('NULL', 'a7a43140eeafc54cd0a91075a2adb019'