Update order_products

[sandwick]

I did an update to my products file by dropping the table an uploading new data, and now my ORDER HISTORY does not match, because the product_id in the products table has changed ...

 

I have the query here that should work but I am having no luc with it, can someone tell me why I am getting a parse error #1064 .... :angry:

 

UPDATE orders_products, products

SET

orders_products.products_id = products.products_id

WHERE

orders_products.products_model = products.products_model

 

Here is the ERROR I am getting ...

 

 

#1064 - You have an error in your SQL syntax near 'products

SET

orders_products.products_id = products.products_id

WHERE

order' at line 1

 

 

 

Any help would be appreciated !!!

 

Thanks !!!

 

// Larry