Hi I have this working for the query to output the result but the if zero results echo is not working, and I cnat see why, if anyone can help please, there is no error that comes up and to test there is nothing in the database table, it works when there is something in and echos out the result but not when the result is 0
$result = mysql_query("whatever query") or trigger_error(mysql_error().$sql);
while($row = mysql_fetch_array($result)){
if(mysql_num_rows($result)==0)
{
echo 'there is none....';
}
else
echo 'my stuff that works';
}