a mysql SQL question ------------------------- I am programming a TV guide script and I am getting stuck 1) Admin must be able to add tv listings to a database using a form at http://1001cgi.hypermart.net/project1/admin2.html Please IGNORE all the form fields above "Start date - (mm/dd/yyyy)" can anyone tell me the design of the table fields 1) I want the SQL statement to find out whether there is a overlap in the program timings 2) Weekly schedule must not overlap with monthly schedules and daily schedules and vice versa 3) Some events will span two days (midnight) for eg if there is already an event present in the database whihc repeats monthly 20 JAN 2001 till 20 APR 2001 if the admin tries to add a weekly event say 12 march 2001 and whihc ends on 26 march 2001 the SQL statement must find out that there is a overlap for the date 20 MARCH 2001 of course all the above is for a particular time slot.. How do I design my database for the above situation? Is there a SINGLE select statment which will find out whether there is a overlap ? chris _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
