Kurth Bemis (List Monkey) wrote: > what the hell i wrong in this query? > > $q = "UPDATE userpref WHERE username='kurth' AND > preference=required_hits SET preference=$HTTP_POST_VARS[required_hits]"; > > mysql_error() returns this...You have an error in your SQL syntax near > 'WHERE username='kurth' AND preference=required_hits SET preference=5' > at line 1 > > what gives?
1) This is a PHP list, not an SQL help list 2) The SET clause goes before the WHERE clause -- Stuart -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php