subject:"Re\: \[PHP\] quert problems"

Re: [PHP] quert problems

2002-10-07 Thread Phillip Erskine

SET comes before WHERE $q = UPDATE userpref SET preference=$HTTP_POST_VARS[required_hits] WHERE username='kurth' AND preference=required_hits; _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- PHP

Re: [PHP] quert problems

2002-10-07 Thread Stuart Dallas

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'