Script problem

[Anon]

Hi,
Why won't this display all the rows?

$result = mysql_query($query);
if($row = mysql_fetch_array($result)){

echo "<font face=\"Verdana\" size=2>{$row['CatName']}&nbsp;-&nbsp;</font><a href=\"melb_edit_cat1.php?id={$row['CatID']}\"><font color=\"red\" face=\"Verdana\" size=2><b>Edit</b></font></a><br>\n";
}
else
{
echo "<font face=\"Verdana\" size=2><B>There are <u>no</u> sub-categories</B></font>";
}

Can any one see where i have gone wrong?
sim

[dar-k]

$result = mysql_query($query);
if(mysql_num_rows($result) == 0){

echo "<font face=\"Verdana\" size=2><B>There are <u>no</u> sub-categories</B></font>";

} else {

while ($row = mysql_fetch_array($result)) {

echo "<font face=\"Verdana\" size=2>{$row['CatName']}&nbsp;-&nbsp;</font><a href=\"melb_edit_cat1.php?id={$row['CatID']}\"><font color=\"red\" face=\"Verdana\" size=2><b>Edit</b></font></a>\n";

}

}