Invalid MySQL resource

[Anon]

The following line generates a "Supplied argument is not a valid MySQL result" error although almost the exact same thing worked in other scripts.

$sql = mysql_query("SELECT username FROM users WHERE username='$username' AND password='$password'");

There has to be a problem somewhere but I don't see where. I tried filling in a username and password manually just to try it out and it still did not work.

I'd be grateful for any help.

/Péter LT.

http://www.ypr.34sp.com
The Young Programmer's Rule

[[deleted]]

Use error checking, print the mysql_error() when mysql_query() fails.

[Anon]

Well, I still get that same error. My code is as follows:

function checklogin($uid,$pass) {
$v = 0;
$sql="SELECT * FROM users WHERE username='$uid' AND password='$pass'";
if(mysql_num_rows($sql)) {
$v = mysql_fetch_array($result);
$v = $valid['id'];
} else { $v = 0; }
return $v;
}

[[deleted]]

Where did the mysql_query() go?