Re: [PHP-WIN] notify user of duplicate entry

2001-06-28 Thread Pete Kuczynski
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

RE: [PHP-WIN] notify user of duplicate entry

2001-06-28 Thread Michael Rudel
:[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

[PHP-WIN] notify user of duplicate entry

2001-06-27 Thread Pete Kuczynski
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