[PHP-DB] Time Allocation Issue From: Jefferson Cowart (jeff <email protected>)
Date: 07/29/02

I'm writing a web application in PHP to do referee scheduling for soccer
games. For each game (a single row in a table) I have a cell for
referee. The cell stores an integer that I can do a join on with another
table of people. I need a way to prevent people from being able to
schedule themselves for multiple slots at the same time. (All I care
about is start time, for now I'm going to ignore the issue of a game
ending after the next one has started.) I have tried doing just a unique
index on referee, date, and time but the issue is I use a 0 to indicate
that the slot is open. Because of that I don't see a way to do it
natively in mysql as such each time I do an insert I think I am going to
need to do a select right before to make sure there no conflicts. Is
there any better more efficient way to do this? Perhaps natively in
mysql. TIA

----------------
Thanks
Jefferson Cowart
Jeff <email protected>

Support Open Instant Messaging Protocols
http://www.petitiononline.com/openIM/petition.html 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php