Re: 2 conditions why wont they work??

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 >