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='k

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

[PHP] quert problems

2002-10-07 Thread Kurth Bemis (List Monkey)
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 prefere