Re: 'OR' logic in mySQL query
| From: | Miles Thompson | Date: | Sun, 17 Apr 2005 23:31:04 +0000 |
| Subject: | Re: 'OR' logic in mySQL query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39213@lists.php.net to get a copy of this message | ||
No - OR and AND tests work like this:
(first conditional test) OR (second conditional test)
therefore
((date_received LIKE '$todays_date) OR (date_received LIKE '$yesterdays_date'))
And of course you will check the MySQL docs to confirm that OR does work in the WHERE clause, won't you?
Another way of handling the query is to ask for anything less than two days old, sort of like this:
where date_received >= $today - 2. (And no, that's not accurate syntax.)
Regards - Miles
At 05:04 PM 4/17/2005, Ron Piggott wrote:
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