checked individually, and how busy you expect the system to be overall.
Andrew Hazen
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 8:17 PM
To: [EMAIL PROTECTED]
Subject: RE: data compare and duplicate entries..
IMHO it is an expensive to
Are you writing a php script, perhaps with a form and a submit button,
that connects to mysql?
-Steve.
-Original Message-
From: Tech @NorthWeb [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 9:32 AM
To: mysql
Subject: Fw: data compare and duplicate entries..
hi,
I was looking f
Not sure of your scripting language, but this logic should work. Just
apply it to each web_form variable posted.
Select count(*) as number FROM table WHERE field=value_from_web_form
If number==0 then do your inserts
Else
Echo "Sorry, field=value_from_web_form data already exists.";
Reset f