I keep getting this syntax error
You have an error in your SQL syntax near 'UPADTE w_jewellery_products SET jcref_id='', jsref_id='', product_name='name', ' at line 1
when I try to perform this update and I can't figure out why
$query = "UPADTE w_jewellery_products SET jcref_id='".$_POST["class"]."', jsref_id='".$_POST["series"]."', product_name='".$_POST["name"]."', product_description='".$_POST["description"]."', material='".$_POST["material"]."', weight='".$_POST["weight"]."', size='".$_POST["size"]."', WHERE product_code='".$_POST["product_code"]."'";
Any help would be greatly appreciated.
Thank you
Rob