RE: [PHP-DB] Trapping a mySQL error
| From: | Bastien Koert | Date: | Thu, 28 Jul 2005 04:02:23 +0000 |
| Subject: | RE: [PHP-DB] Trapping a mySQL error | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39987@lists.php.net to get a copy of this message | ||
<?
...
$result = mysql_query($query);
if (mysql_errno($result) == 1062)
{
echo "Already present in database";
}
?>
Bastien
From: JM <frawst1@gmail.com> Reply-To: JM <frawst1@gmail.com> 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