Duplicate Entries

[kyle_pn]

How to begin...

The only thing that cannot be duplicated within the tables I have crated is the group_name. In fact that is the primary key, vs. having an id number.

Now.. When I try and enter a duplicate entry on purpose, it does exactly as it should, it tells me:

1062Duplicate entry 'group_name' for key 1

where group_name = whatever the actual entry is within the column.

What I want to do, is if someone enters a duplicate group_name, and when they submit the form, I want it to say, "Sorry, Duplicate Entry." and take them back to the form, to re-enter a group_name that is not a duplicate.

Getting the error is a good sign, just not knowing how to manipulate the error to do something else.

Thanks in advance to anyone who understands what I am trying to say, and who can also point me in the right direction on what to do.

Kyle

[[deleted]]

when mysql_query() returns false,
check mysql_errno() and find the number that indicates 'duplicate entry' if I remember correctly it is 1062;

if (!$rResult=@("INSERT....))
{
// query failed, why?
if (mysql_errno($rDBConnection)==1062))
{
// duplicate data
}
else
{
// Other error
echo mysql_error($rDBConnection);
}
}
else
{
// query executed ok.
}

[kyle_pn]

Excellent. Thanks, it works perfectly.