I am getting this error when hitting the add button...
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 'Complete - Industry Standard Size", products_price = "11.0
INSERT INTO orders_products set orders_id = "4572", products_id = "908", products_model = "125std-100", products_name = "100 - 1 1/4" Complete - Industry Standard Size", products_price = "11.0000", final_price = "11", products_tax = "6", products_quantity = "1"
[TEP STOP]
It is because I have double quotes in the product names. ex: 1" button parts
It does not happen when I have no quotes in the name.
Thanks!
Lyle