Updating database problems

davidrtg

[b][red]This message was edited by davidrtg at 2003-11-28 13:33:25[/red][/b][hr]
I'm trying to update a record with the following code and its not working. $dbh is working and pulling stuff from the database. Can you see any reason as to why this wouldn't update the record?
[code]
$dbh->do("UPDATE directory SET name = '$name', desc = '$desc' WHERE id = $i");
[/code]I've tried name = $name as well id = '$i'. I know that $i is equal to the ID number of the record that I want to update.

This is the error from the error_log file
[code]
You have an error in your SQL syntax near 'desc = 'Saw Sharpening' WHERE id = 1' at line 1 at admin.cgi
[/code]

Thanks,
David

Jonathan

: [b][red]This message was edited by davidrtg at 2003-11-28 13:33:25[/red][/b][hr]
: I'm trying to update a record with the following code and its not working. $dbh is working and pulling stuff from the database. Can you see any reason as to why this wouldn't update the record?
: [code]
: $dbh->do("UPDATE directory SET name = '$name', desc = '$desc' WHERE id = $i");
: [/code]I've tried name = $name as well id = '$i'. I know that $i is equal to the ID number of the record that I want to update.
:
: This is the error from the error_log file
: [code]
: You have an error in your SQL syntax near 'desc = 'Saw Sharpening' WHERE id = 1' at line 1 at admin.cgi
: [/code]
Hehe....desc is a MySQL keyword. I guess name is too, probably. Put backticks around field names to escape them, like `desc` and `name` and it should work fine.

Jonathan

###
for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
(tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
/(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");