If no results...then do this!

[netfrugal]

Here's a simple while statement:

$sql = mysql_query("SELECT * FROM table'");  

while ($row = mysql_fetch_array($sql)) {
$recID= $row['recID'];

<tr><td><? echo $recID; ?></td></tr>

}

If there are no rows to display, how do I echo this? Rather than showing no rows at all?

[scrupul0us]

if (!$row)
{
echo "no rows";
}

[NogDog]

$sql = mysql_query("SELECT * FROM table'");  

if(mysql_num_rows($sql)) 
{
   echo "<table>\n";
   while ($row = mysql_fetch_array($sql)) 
   {
      printf("<tr><td>%s</td></tr>\n", $row['recID']);
   }
   echo "</table>\n";
}
else
{
   echo "<p>No matching data found.</p>\n";
}