valid result

[scoutt]

I get this error when I run my page.

"Supplied argument is not a valid MySql result" or something
on this line in bold


function in_use($username){
global $username;

$sql = "select name from $usr_tbl where name = '$username' ";
$result = mysql_query($sql);
if(!mysql_num_rows($result)) return 0;
else return 1;

}

I am trying to see if the user name is already taken. can anybody tell me what I'm doing wrong?

TIA

[scoutt]

resolved..