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. How could I trap this error and display a custom message to handle the situation better? Thanks in advance. John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php