[Resolved] Mysql dont return nothin...

[fuzic]

I have a script which doesnt seem to work... It is supposed to pull information out of a table, where the information in a certain field is equivilent to the submitted variable "$user", but it doesnt pull anything out, no matter what $user is equal to. Any help appriciated.

mysql_select_db("markar_nu_-_users", $db);
$query2 = "SELECT * FROM users WHERE user = $user";
$result2 = mysql_query($query2);
if ($result2) {
	echo "This wiener has already been taken!";
} else {

[LordShryku]

Unless $user is a number, pulling from a number field, it should be quoted. And you should use mysql_error() to find out the problem

$query2 = "SELECT * 
             FROM users 
            WHERE user = '".$user."'";
$result2 = mysql_query($query2) or die(mysql_error());