Why does my mysql_num_rows not work?

Nothing is wrong with my query I don't think: "SELECT * FROM users WHERE username='" . $u . " ' "; But for some reason, when I write out: mysql_num_rows($query) or die('can\'t execut num rows'), it just tells me it's not working. this confuses me...