Re: 2 conditions why wont they work??

Well, that's probably because of the data - no entries with both conditions satisfied... Use "or" if that's what you actually want to do. ;-) Bogdan Brad Wright wrote: > Ahh..that seems to have fixed it. Its now pulling NO data, but is not giving > error msg.... > thanks, 1/2 way there now :) > > brad > > > From: Bogdan Stancescu <mgv@fx.ro> > > Date: Mon, 11 Feb 2002 05:46:46 +0200 > > To: Brad Wright <bradwright@optushome.com.au> > > Cc: PHP General List <php-general@lists.php.net> > > Subject: Re: [PHP] 2 conditions why wont they work?? > > > > No, with your syntax it won't. You have to quote it in the query, as in > > $query2 = "select * from Table where userNo = $userNo and clientID = > > '$clientID'"; > > > > Bogdan > > > > Brad Wright wrote: > > > >> Thanks, > >> > >> $clientID is a string but is not empty...already tried echo($clientID) and > >> it is not empty. > >> > >> Did you mean that if the value of $cientID is a string it wont work???? > >> > >> Thanks > >> Brad > >> > >>> From: Bogdan Stancescu <mgv@fx.ro> > >>> Date: Mon, 11 Feb 2002 05:38:31 +0200 > >>> To: Brad Wright <bradwright@optushome.com.au> > >>> Cc: PHP General List <php-general@lists.php.net> > >>> Subject: Re: [PHP] 2 conditions why wont they work?? > >>> > >>> Do an echo($clientID) before - it most probably is either empty or it's a > >>> string and MySQL actually issues errors there. > >>> > >>> Bogdan > >>> > >>> Brad Wright wrote: > >>> > >>>> Hi all, > >>>> Im was sure you could select a row from a mySQL database based on 2 > >>>> conditions. My code: > >>>> > >>>> $query2 = "select * from Table where userNo = $userNo and clientID = > >>>> $clientID"; > >>>> $result2 = mysql_query($query2,$db); > >>>> > >>>> This returns : > >>>> Warning: Supplied argument is not a valid MySQL result resource > >>>> > >>>> b ut if i change the line to: > >>>> $query2 = "select * from Table where userNo = $userNo; > >>>> $result2 = mysql_query($query2,$db); > >>>> > >>>> it works (but get all the rows with userNo = $userNo. > >>>> > >>>> HELP!!!! Im sure this should work...what am i doing wrong??? > >>>> > >>>> -- > >>>> PHP General Mailing List (http://www.php.net/) > >>>> To unsubscribe, visit: > >>>> http://www.php.net/unsub.php > >>> > >>> > >>> -- > >>> PHP General Mailing List (http://www.php.net/) > >>> To unsubscribe, visit: > >>> http://www.php.net/unsub.php > >>> > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php