Custom Duplicate Entry

Echoing back to page if Unique Field is a duplicate.

[inveni0]

I have a form users can fill out in which they create a unique field. How can I simply echo back to the page if the text they enter already exists in the database without the ugly old default error?

[dreamcatcher]

Don`t use mysql_error(), instead test the state of the query.

$query = mysql_query("...

if ($query)
{
//ok
}
else
{
//not ok
}

dc

[inveni0]

I'm not sure I understand.

[jatar_k]

try and select the row using the data they enter, if it returns something then it is duplicate data, if it does not then you can carry on with your insert.

[dreamcatcher]

When you said 'ugly old default error' I figured you meant the error that using mysql_error() throws? So, instead of using that test the query. Or do as jatar_k mentioned.

dc