query question

[crawfd]

How would I add an if statement that implies "if zero rows/entries exist for a user, then print "No rows/entries exist"? Thanks

$query = mysql_query("Select * FROM $table WHERE username = '".$_SESSION['username']."' order by date DESC",$db);

//code

while(list($id,$date,$username,$title,$entry,$awareness,$pagination) = mysql_fetch_row($query)){

//code

}

[LordShryku]

before you use mysql_fetch_row, use [man]mysql_num_rows[/man]. If that is 0, then show your no rows message.