Data fetch from database in php in special conditions

<?php
$i=1;
while($row=mysql_fetch_object($result))
{
?>
<tr>
<td align="center"><?php echo $i; ?></td>
<td align="center"><img src="<?php echo $row->image; ?>" height="45" width="60" /></td>
<?php
$querya="select * from catagory where id='$row->Catagory'";
$resulta=mysql_query($querya) or die (mysql_error());
$rowa=mysql_fetch_object($resulta);
?>
<td align="center"><?php echo $rowa->name; ?></td>
<?php
$queryc="select * from subcatagory where id='$row->Subcatagory'";
$resultc=mysql_query($queryc) or die (mysql_error());
$rowc=mysql_fetch_object($resultc);
?>
<td align="center"><?php echo $rowc->name; ?></td>
<td align="center"><?php echo $row->name; ?></td>
<td align="center"><?php echo $row->price; ?></td>
<td align="center"><?php echo $row->sku; ?></td>
<td align="center"><?php echo $row->description; ?></td>
<td align="center"><?php echo $row->date; ?></td>
<td align="center"><a href="product_edit.php?id=<?php echo $row->id; ?>">EDIT</a> | <a href="product_delete.php?id=<?php echo $row->id; ?>" onclick="return confirm('Are You Sure To Delete')">DELETE</a></td>
 </tr>
<?php
$i++;
}
?>