My Sql Php, does a user exists?

Question

Hi,

I need a query that finds out if an entered username exists in the database

So if $username in users table = $entered_username

echo "it exists"

else echo "it doesnt exist"

whats the correct syntax

ive been trying but i cant figure it out

Thanks?

Answer 1

$query = "SELECT user_id FROM users WHERE username='$username';";
if($result = mysql_query($query)){
if($row = mysql_fetch_array($result)){
$userId = $row['user_id'];
}
}

if($userId > 0){
echo "it exists";
}
else{
echo "it doesn't exist";
}

Answer 2

if ($username == $entered_username)
{
echo "it exists";
} else {
echo "it doesn't exist";
}

Is that what you are asking? Or do you want syntax to retrieve the username from the database?

Answer 3

Your 151st question on how to program...
You are abusing this service, getting aswers from decent programmers to cover for your total incompetence.
Learn PhP through www.php.net.

Answer 4

It would be something like

SELECT user_name FROM users WHERE
username = $_GET['username'];