err i mean ... an 'or' statement sry
is there an 'and' statement for mysql, when you are doing multiple "where"s?
MySQL allows SQL statements that support both AND and OR. With OR, you can often use IN instead.
SELECT columns FROM tablename WHERE (condition1) AND (condition2)...
All of this is in the MySQL manual, of course.
Larry
PS Technically speaking, this question would have been more appropriate on a MySQL list (or the PHP-DB list).
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
