intercepting mysql error code in php

[betrollwin.com]

When someone enter info into a form, it gets uploaded into the mysql database. When a duplcate is found in a row declared as unique, I get error message:

Duplicate entry 'testemail@g.com' for key 1

How would I make it say something else like:

You have entered an email already in our database.

[siteguru]

$sql = "INSERT INTO table yada yada";

if ( !@mysql_query ($sql) ) {
echo "It looks like the query did a boo-boo. Please try again";
}

http://us3.php.net/manual/en/function.mysql-query.php

[mniessen]

Before trying to insert the data into yoiur database, you can check if the e-mail already exists:

$result = mysql_query("SELECT * FROM table WHERE email='email@domain.com'");
$num_rows = mysql_num_rows($result);
if($num_rows == 1) {
    echo "You have entered an email already in our database.";
} 

Regards,

Michaël

[siteguru]

Related thread.

http://www.sitepoint.com/forums/showthread.php?t=399291

[r937]

Michaël, no, he just got finished a thread where it was pointed out that you do not need to do that -- for one thing, it's not necessary to do yourself what the database can easily and more efficiently do, and for another thing, it doubles your processing time