I'm not sure if you can...  What I usually do is do a query to see if
there's already an entry there, and display an error message if there is.
Another thing to you can do is allow duplicate entries, and use the DISTINCT
option in the SELECT statement.  This wouldnt be as efficient, so i'd try
the query check first.  If there is a way to disallow duplicates, i'd love
to know.


"Jeff Gannaway" <[EMAIL PROTECTED]> wrote in message
> Does anyone know how to set a column in a MySQL table to disallow any
> duplicate entries.
> I've already got a PRIMARY KEY defined for this table.  I tried setting
> other field to a MUL KEY, hoping that it would not permit duplicates, but
> it does.
> I've searched the MySQL docs without success. I wish their site was a good
> as PHP.net.
> Later,
> Jeff Ganaway
> ___________________________________________________________
> Save 15% on 2002 Calendars and Holiday Cards!
> http://www.AvantGifts.com
> Discount Code: hopper22ct
> Offer Good Through October 31, 2001
> ___________________________________________________________

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to