Thanks Andrian,
Paul DuBois suggested the same thing you did.
The column that concerns me is already UNIQUE,
so all I need to do is something like this, after the insert statment
in PHP like you suggest:
// check if row is returned, if yes error, if no insert
if (mysql_affected_row
:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
___
> -Original Message-
> From: Pete Kuczynski [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 27, 2001 7:30 PM
> To: PHP Lists
> Subject: [PHP-WIN] notify user of duplic
I want to prevent duplicate entries in by database in the hostname
field.
So far, I have modified my hostname column as such to prevent duplicate
entries into it, it works:
alter table modify varchar(15) null unique;
Now I need to notify the user that enters a duplicate hostname of their
erro