whhdegzsxv
New Member
I just cant figure out why am getting error 1064 from this query\[code\]//prep the data for database use$manufacturer_id = $_GET['id'];$manufacturer_display_name = mysql_prep($_POST['manufacturer_display_name']);$manufacturer_name = mysql_prep($_POST['manufacturer_name']);$query = "UPDATE IT_manufacturer SET manufacturer_name = '{$manufacturer_name}', manufacturer_display_name = '{$manufacturer_display_name}', WHERE manufacturer_id = {$manufacturer_id} ";$result = mysql_query($query, $connection);confirm_query ($result);\[/code\]If I echo the variables $manufacturer_name, $manufacturer_display_name, $manufacturer_id they all have values but am getting this errorcould not excecute queryYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE manufacturer_id = 1' at line 4 error number 1064Any help