I have an update statement which should update a product using information the user has submitted from a form
The error being that nothing gets updated, the sql code does nothing, and changes nothing in the database
Can anyone see an error in the code?
$user_id = ($_SESSION['user_id']); $product_id = ($_POST['product_id']); $sql_updateProduct = "UPDATE products SET title = '$_POST[title]', director = '$_POST[director]', cert_id = '$_POST[certificate]', cat_id = '$_POST[category]', format_id = '$_POST[format]', condition_id = '$_POST[condition]', user_id = '$user_id', description = '$_POST[description]', image = '$_POST[image]' WHERE product_id = '$product_id'"; mysql_query($sql_updateProduct) or die (mysql_error()); echo"<h1>Record Updated</h1>";
Everything above this section of code works fine, I have narrowed the issue down to this section of code. Any help would be much appreciated.