[SOLVED] How to fix this MySQL query?

[LooieENG]

	$result = mysql_query("SELECT $username FROM users");
$queries++;
if (mysql_num_rows($result) == 0) {

 

Gives

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /xxx/xxx/ on line 11

[Ken2k7]

Is $username the name of a column? That's really strange.

 

SELECT * FROM `users` WHERE `username` = '$username'

[LooieENG]

Ah, woops. I have the column "username" and I wanted to search for $username

 

Do I need to use * because I only want to check if the username exists?

[DarkWater]

It doesn't matter.

[Ken2k7]

function username_exists ($username) {
    $query = "SELECT `username` FROM `users` WHERE `username` = '$username' LIMIT 1";
    $result = mysql_query($query) or die(mysql_error());
    return mysql_num_rows($result) == 1;
}

[LooieENG]

Thanks for the help