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

Thank you that did exactly what I was looking for.

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

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

> -----Original Message-----
> From: Ryan Fox [mailto:rfox <email protected>]
> Sent: Monday, July 29, 2002 16:08
> To: Jefferson Cowart
> Cc: mysql <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
> rfox <email protected>
> 

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