Re: 2 conditions why wont they work??

Bogdan, It appears that $clientID is saved with a space at the start .. when i check for its value (using session_encode() ) it gives that value " test 3" when it should be "test 3". <input type="hidden" name="XclientID" value="<?php echo $row["clientID"];?>"> this is the extract form the form on the previous page which sets $clientID. I am sure that a space is being added but cant find where. Thanks for yr help, Brad > From: Bogdan Stancescu <mgv@fx.ro> > Date: Mon, 11 Feb 2002 05:53: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?? > > 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 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >