11 Jun
2002
11 Jun
'02
1:39 p.m.
Hi everyone...
I'm trying to update a few columns on one row using an sql statement, but I don't seem to have the correct syntax...
I'm using :-
$dbh->do("update <tablename> set <column1> = <new-value1> <column2> = <new-value2> where <column3> = <value3>");
This doesn't work... however if update only one column it does, so I figure I must be missing something. I've looked through the docs and can only find update examples with one column to be updated.
Please help!!!!!!
Simon