How to show no results

[cmdr_bond]

Hello,

I have the following code:

$result = mysql_query("SELECT * FROM inventory Where ProductType='$type",$db);

$myrow = mysql_fetch_array($result);

But what if $type=fruit and there are no fruit listed in the inventory table. Can I have the PHP show alternate HTML (not just one line of code) so it can look differnt for not having anything displayed?

Thanks

[planetsim]

$result = mysql_query("SELECT * FROM inventory Where ProductType='$type",$db);
if (mysql_num_rows($result) == 1)
{
    $myrow = mysql_fetch_array($result);
}
else
{
    echo "Query Error";
}

[cmdr_bond]

It works! -- Thanks