mysql_num_rows and where

[violinrocker]

i have this code and it doesnt seem to work.... when i remove "WHERE" it works

 

$query = mysql_query('SELECT * FROM `friend_requests` WHERE `username` = `$session->username`');

echo "[<a href=\"newfriends.php\">Friend Requests(<font color='red' face='Arial'>".mysql_num_rows($query)."</font>)</a>]"

[Sergey Popov]

Try to do this:

$query = mysql_query("SELECT * FROM friend_requests WHERE username = '".addslashes($session->username)."'");

[violinrocker]

whew.. thanks a lot... it works now... been fixing it for hours haha thanks again