MySQL Syntax Error FRUSTRATING!

[a_bains]

I get this error with the code below:

 

Could not update PC serials: 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 'case='case', psu='psu', cpu='cpu', mobo='mobo', ram='ram', hdd='hdd', video='vid' at line 1

 

 

<?php

$title="Update PC";

include("header.php");

echo "<div id='nav'><a href='details.php'>Details</a> | <a href='workorder.php'>Add Work Order</a> | <a href='addpc.php'>Add PC</a> | <a href='index.php'>Search</a></div>";

require("connect.php");

if ($submit == "yes") {

$sql_serial = "UPDATE computers SET case='case', psu='psu', cpu='cpu', mobo='mobo', ram='ram', hdd='hdd', video='video', drives='drives', pci='pci', other='other' WHERE computer_id=$computerid";
mysql_query($sql_serial) or die('Could not update PC serials: ' . mysql_error());

[AndyB]

http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

 

case is a reserved word. Either wrap it with `backticks` in the query or best of all, change your table field names to avoid using reserved words.

[a_bains]

Yep, your right I just figured that out from searching a previous post. Thx alot!