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
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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php