Duplicate File Name

[Anon]

Hi, I have a databse with a tablw with a field that is "name", I want a php program to check to see if there is a duplicate name in the field, if there is print out a message.

Can anyone help?

Thanks

[come2go]

Table T

$Ret=mysql_query("SELECT T.idName FROM T WHERE strcmp(idName,'".addslashes($Name)."')==0")

if(!mysql_num_rows($Ret)) {
echo "Not Found";

// header(...) for reload
}

[Anon]

if (mysql_num_rows(mysql_query("select * from table where name = '$name' limit 1"))) {
print("Name already in use!");
}

"limit 1" will make MySQL stop searching the table once it finds a first record (which is OK since you don't want to know more than that).

Don't forget to addSlashes() or mysql_escape_string() all PHP variables you use in SQL queries.

• Hendrik