> Here it comes, I am programming an online schedule, and I need to know at > a > certain moment, how many events can occur, for instance, how many tasks to > be done at 9:00 am, with the problem that users can insert tasks selecting > hour and minute of start and end time, for instance, item1 takes from 8:00 > to 9:50, item 2 from 8:45 to 9:10, so at 9:00 it should return 2 items > concurring... SELECT * FROM table WHERE value BETWEEN start AND end Where value is the date/time you're looking for and start and end are datetime (or some date type) in your database. ---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
