Num_rows always returning false

[darkfreaks]

for some reason  it is returning false and the message flag for my script always appears disabled.

 

 

 

example code

$num_rows= mysql_num_rows($result);
if($num_rows < 1) {

//disable
}else{
//enabled
}

[Maq]

Show us a few lines before that, your query is most likely failing and your $result is not a resource id.

 

Echo $num_rows, see what the value is.

[darkfreaks]

i think i found the problem i am using a session to pass the  USER ID. but not sure.

 

$m_id = $_SESSION['id'];
    	
        $result = mysql_query("SELECT * FROM notifications WHERE member_id=$m_id AND status=1");
        $num_rows = mysql_num_rows($result); 

[Maq]

Echo your query to make sure it's correct, particularly the $m_id, and put in or die(mysql_error());