[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?
$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
You have an error in your SQL syntax near 'desc = 'Saw Sharpening' WHERE id = 1' at line 1 at admin.cgi