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 rather get the name of the unique key, in this case I named it `IDX_EMAILADDR`.

Any ideas? Thanks

_________________________________________________________________
Send and receive larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es



-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to