Re: [PHP-DB] WHERE statement used multiple times.

[JeRRy]

Chris wrote:


You can put together WHERE statements with an AND or
an OR.  For
instance, SELECT id FROM users WHERE id='2' OR
id='3'

You know, if you had a few suspicions about this sort
of thing you 
could
always give it a spin in a Query.  Worst case scenario
is you will get
an error.

- Chris



Thanks Chris, the help is mostly appreciated.  I have
got the code to skip emails that are flagged with a y
vlaue in emailerror field.  :)  

Thanks again.

Jerry

http://personals.yahoo.com.au - Yahoo! Personals
New people, new possibilities. FREE for a limited time.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] WHERE statement used multiple times.

[Chris Wanstrath]

On Mon, 2003-10-20 at 00:56, JeRRy wrote:
   Hi,
  
  If I was to want to use the WHERE statement multiple
  times (more than once) how do I seperate each WHERE
  statement?
  
  Would it be with a ',' (coma) or a ' ' (space) or
  what?  Or not possible to have multiple WHERE's in
  the
  one query?
  
  I need 2 tables checked before executing the
  results. 
  So that is why I need 2 WHERE statements done.  
  
  Thanks!
  
  http://personals.yahoo.com.au - Yahoo! Personals
  New people, new possibilities. FREE for a limited
 time. 

You can put together WHERE statements with an AND or an OR.  For
instance, SELECT id FROM users WHERE id='2' OR id='3'

You know, if you had a few suspicions about this sort of thing you could
always give it a spin in a Query.  Worst case scenario is you will get
an error.

- Chris

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php