Nil Return

Anon

I have a simple array that works but I would like to include an echo if there is no listing on the database. What and where would I put it into the array

<?php

$db = mysql_connect("host","hostname","password");
mysql_select_db("databasedb",$db);

$result = mysql_query("SELECT * FROM companys WHERE listing = '$listing' and member = '1' ORDER by area ASC",$db);

while ($myrow = mysql_fetch_array($result))

{
echo("<table width=\"700\" border=\"0\" align=\"center\"><tr>");
echo("<td width=\"100\">" . $myrow["area"] . "</td>");
echo("<td width=\"150\">" . $myrow["name"] . "</td>");
echo("<td width=\"250\">" . $myrow["text"] . "</td>");
echo("<td width=\"70\"><a href=\"client.php3?id=" . $myrow["ID"] . "\">visit</a></td>");
}
mysql_free_result($result);
?>

Any Ideas ??

Anon

This should work for you.
<?php

$db = mysql_connect("host","hostname","password");
mysql_select_db("databasedb",$db);

$result = mysql_query("SELECT * FROM companys WHERE listing = '$listing' and member = '1' ORDER by area ASC",$db);

if (!mysql_num_rows($result))

{
echo "Your message here";

}

print mysql_error();

while ($myrow = mysql_fetch_array($result))

{
echo("<table width=\"700\" border=\"0\" align=\"center\"><tr>");
echo("<td width=\"100\">" . $myrow["area"] . "</td>");
echo("<td width=\"150\">" . $myrow["name"] . "</td>");
echo("<td width=\"250\">" . $myrow["text"] . "</td>");
echo("<td width=\"70\"><a href=\"client.php3?id=" . $myrow["ID"] . "\">visit</a></td>");
}
mysql_free_result($result);
?>