[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    [PHP-DB] RE: Time Allocation Issue
From:       "Jefferson Cowart" <jeff () cowart ! net>
Date:       2002-07-29 23:51:25
[Download RAW message or body]

Thank you that did exactly what I was looking for.

----------------
Thanks
Jefferson Cowart
Jeff@cowart.net 

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

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


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

[prev in list] [next in list] [prev in thread] [next in thread]