Re: [PHP-DB] Trapping a mySQL error

2005-07-28 Thread JM
gt; > > > ?> > > > > Bastien > > > > >From: JM <[EMAIL PROTECTED]> > > >Reply-To: JM <[EMAIL PROTECTED]> > > >To: "php-db@lists.php.net" > > >Subject: [PHP-DB] Trapping a mySQL error > > >Date: Wed, 2

RE: [PHP-DB] Trapping a mySQL error

2005-07-27 Thread Bastien Koert
Bastien From: JM <[EMAIL PROTECTED]> Reply-To: JM <[EMAIL PROTECTED]> To: "php-db@lists.php.net" Subject: [PHP-DB] Trapping a mySQL error Date: Wed, 27 Jul 2005 17:13:09 -0700 Hi all, I have a table with the record_id as the unique primary key and another column (the

[PHP-DB] Trapping a mySQL error

2005-07-27 Thread JM
Hi all, I have a table with the record_id as the unique primary key and another column (the record_name) as unique as well. This is working how I want it to. I want unique record_names. When the user tries to add a record with an existing record_name the sql statement execution fails: error 1062.