Just a quick 1

[Megahertza]

I want to check if a username exist on my mysql db table. How can I check if a result comes back so i don't get duplicate usernames. This is my query. Thanks guys

$user_query = mysql_query("SELECT uid,username FROM users WHERE username = '$username'")
or die(mysql_error());

[herve]

function CheckName($username)
{
     // Connection stuff to the DB here (or use global var.)

 $result = mysql_query("SELECT uid,username FROM users WHERE username = '$username'")
or die(mysql_error()); 

$myrow = mysql_fetch_array($result);

if ($myrow)
{
   // There's a result, so at least one name corresponding

   return (1);

}
else
{
   // No corresponding name

    return (0);

}
}


and at the main level :

if (CheckName($myname))
{
    print "Welcome $myname !";
}
else
{
    print "I don't know you !";
}