> I have a table where one of the columns has a date time field. I am rtying > to build a query that will pull all results between the current date and > up to 48 hours (2 days) ago. I have tried various queries using examples > like below... SELECT * FROM calls WHERE event_date_time BETWEEN NOW() - INTERVAL 2 DAY AND NOW() ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
