You might want to pattern you SELECT statement in this manner:
SELECT * FROM `tablename` WHERE status = 3 OR status = 1
Advertising
Notice I called the field name explicitly on each side of the OR.
Be sure to check the data type for the date field -- if it is a datetime
stamp or date stamp, it might complain with the use of "like"
You ought to check out:
http://dev.mysql.com/doc/mysql/en/where-optimizations.html
Mark Cain
----- Original Message -----
From: "Ron Piggott" <[EMAIL PROTECTED]>
To: "PHP DB" <php-db@lists.php.net>
Sent: Sunday, April 17, 2005 4:04 PM
Subject: [PHP-DB] 'OR' logic in mySQL query
> Am I able to use the OR logic in mySQL queries?
>
> $query = "SELECT * FROM table WHERE date_received LIKE '$todays_date' OR
> '$yesterdays_date' ORDER BY prayer_request_reference ASC";
>
> In this above example will the " OR '$yesterdays_date' " work?
>
> In reality I am wanting to preview new entries to the database within the
> past 2 days
>
> Ron
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php