<?
...
$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

Reply via email to