[RESOLVED] Check if username and email exist

[team_lh_Max]

Hey,

I am building a registration form and so far coming along great, but now i am stuck in front of something i have never really worked before yet.

Before people register i somehow have to check the database for the email and username they submitted so no double registrations occur. But I have no idea once i got the array with all usernames by for example

Code:

SELECT user_name FROM login_table

how to check if the provided username is in this error.

Can someone help me and point me in the right direction please?

Thanks for your help as usual
Max

[error_22]

$sql = "SELECT * FROM table_name";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_object($result))
{
if ($row->username_field == "$REQUEST[username]") // $REQUEST[username] is the data inserted in the username field in your registration form
{
echo "username already taken";
}}

[kakki]

or this:

$sql = "SELECT COUNT(*) FROM table_name WHERE username='".$REQUEST[username]."' ";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_row($result))
if ( $row[ 0 ] > 0 )
{
echo "username already taken"; 
}

[team_lh_Max]

okay thanks you guys