Re: quert problems
| From: | Stuart Dallas | Date: | Mon, 07 Oct 2002 15:09:53 +0000 |
| Subject: | Re: quert problems | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-119083@lists.php.net to get a copy of this message | ||
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