quert problems

From: Date: Mon, 07 Oct 2002 15:02:53 +0000
Subject: quert problems
Groups: php.general 
Request: Send a blank email to php-general+get-119081@lists.php.net to get a copy of this message
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? ~kurth

« previous php.general (#119081) next »