使用while循环检查数组是否为空

Question

I have read several of these posts on the site, but still can't find the answer to my problems. I have a while loop where for every entry in the database the table populates. Although if the table in the database is empty, I want it to display a messaged instead. Any ideas of what is wrong here? (aware of the deprecated tags)

$result = mysql_query("SELECT * FROM blog");

while($row = mysql_fetch_array($result))                    
{           
   if(count($row) === 0)
   {
      echo 'No Data';
   }

   <table code>

}

Answer 1

Use mysql_num_rows for counting rows from DB.

<?php

if (mysql_num_rows($result) > 0) {
    echo '<table>';
    while ($row = mysql_fetch_assoc($result)) {
        echo '<tr>...</tr>';
    }
    echo '</table>';
} else {
    echo 'No result found';
}

?>

EDIT: updated code for table.