[SOLVED] problem with excact value matching in mysql

[gli]

  if (($username != $usernamecheck )	
        &&  ( $email != $emailcheck )) { echo "registered" } 

what code for php is to check in mysql in users table for $username is it matching to any username value in all database table rows.

 

sorry for my bad english.

 

[benphp]

<?php 
$sql = "SELECT username FROM users WHERE username = '$username' ";
$result = mysql_query($sql) or trigger_error("SQL", E_USER_ERROR);
while($row = mysql_fetch_row($result))	
{
$usernameCheck	= $row[0];	
if (($username == $usernamecheck)) { 
	echo "registered" 
} 
}

?>

[wildteen88]

You'd have to run a SQL Query against your database, exmaple:

 

$qry = "SELECT * FROM your_table WHERE `username`='$username'";
$result = mysql_query($qry) or die('Query error:- ' . mysql_error());

// now to see if your query returned a match, you'd check to see the number of returned rows equals to one:
if(mysql_num_rows($result) == 1)
{
    echo '<b>'.$username.'</b> Exists!';
}
else
{
    echo '<b>'.$username.'</b> Does not exist!';
}

[gli]

ok thnx