Hi Brian, > What would the SQL be to find a record where: > start_date < today <= end_date
... WHERE start_date < today AND today <= end_date If you're asking "how do I get today's date into an SQL statement", there are two ways: - use your DBMS's built-in function to get today's date - use PHP's date() function to format a timestamp as YYYY-MM-DD Cheers Jon -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
