List:General Discussion« Previous MessageNext Message »
From:Werner Stuerenburg Date:August 3 2001 8:15am
Subject:Re: data checking during input?
View as plain text  

Chip schrieb am Freitag, 3. August 2001, 08:08:29:

> I have a database I enter data into from a web based php form.
> I wonder if there is a way to have mysql check the database for
> a duplicate entry before it gets written into the database? And
> inform me of such so I will not have duplicate entries?


A very simple way to insure this is to put a unique index on the
appropriate column(s). In fact, that's the trick of the trade.

-- 
Herzlich
Werner Stuerenburg            

_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de


Thread
data checking during input?Chip3 Aug
  • Re: data checking during input?Werner Stuerenburg3 Aug
  • Re: data checking during input?Stefan Hinz3 Aug
RE: data checking during input?Adam Douglas3 Aug