<? ... $result = mysql_query($query); if (mysql_errno($result) == 1062) { echo "Already present in database"; }
?> Bastien
From: JM <[EMAIL PROTECTED]> Reply-To: JM <[EMAIL PROTECTED]> To: "php-db@lists.php.net" <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 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
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php