Thank you that did exactly what I was looking for. ---------------- Thanks Jefferson Cowart [EMAIL PROTECTED]
Support Open Instant Messaging Protocols http://www.petitiononline.com/openIM/petition.html > -----Original Message----- > From: Ryan Fox [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 29, 2002 16:08 > To: Jefferson Cowart > Cc: [EMAIL PROTECTED] > Subject: Re: Time Allocation Issue > > > > 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. > <snip> > Is > > there any better more efficient way to do this? > > Use null to indicate the slot is open. Your unique index can have > multiple null values, but not multiple zero values. I believe this is > what you are looking for. > > Cheers, > Ryan Fox > [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
