Statement question

Anon

Hi all,
The following is a snippet of my code:

<?php
include("include/dbconnect.php");

if($id){
$query = "SELECT * FROM list WHERE Address='$id'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
echo "<a href=\"book.php?id={$row['CatID']}\">{$row['CatName']}</a> \n";
}
?>

If there were no values in the database how would i change the script to echo an error message?
Thanx,
wado

Anon

<?
while($row = mysql_fetch_array($result)){
if (!$row) {echo 'no data in this record';}
else {
echo "<a href=\"book.php?id={$row['CatID']}\">{$row['CatName']}</a> \n";
}
}
?>

an empty array returns false

Anon

if (mysql_num_rows($result)==0)
{
echo "error";
}
else
{
while($row = mysql_fetch_array($result)){
echo "<a href=\"book.php?id={$row['CatID']}\">{$row['CatName']}</a> \n";
}