[Resolved] Spot the syntax error

[Kudose]

Hello all.

I've got this query:

$doc_sql = "UPDATE ".$prefix."departments SET title='$title', ";
$doc_sql .= "manager='$manager', email='$email', hours='$hours', ";
$doc_sql .= "phone='$phone', fax='$fax', desc='$desc' WHERE did='$did'";

That produces:

MySQL said: 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 'desc='73571NG' WHERE did='0'' at line 1

Can anyone offer any insight?

TIA.

[Sxooter]

desc is a keyword. Try naming that field something else or quoting it.

[Kudose]

\m/( >.< )\m/

Thanks. I wonder why I never think of stuff like that. Bleh.

[Sxooter]

You've just not been bitten by it as many times as I have... yet.