lated, issue
selects for each of the unique contrained columns to determine which one was
violated"?
Thanks
From: Jeremy Zawodny <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Scot Campbell <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Unique Key Violation - How
ns the non-duplicate data (i.e., error message on the email address
vs. error message on the userid field).
From: Jeremy Zawodny <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Scot Campbell <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Unique Key Violation - How to de
uniqueness via individual selects before I issue the insert.
Thanks
From: Jeremy Zawodny <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Scot Campbell <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Unique Key Violation - How to determine which key
Date: Tue, 16 Sep 2003 20
I have a table w/ a primary key and 2 additional unique keys.
How can I determine which key was in error when a key violation occurs
(error=1062)?
The call is issued from PHP (4.4.3).
I can retrieve a message w/ mysql_error() which returns "Duplicate entry
'[EMAIL PROTECTED]' for key 3"
I'd r