[SOLVED] Only showing one result

[Tainted Kitten]

<?php

$query  = "SELECT * FROM registereddogs WHERE `Sire` LIKE '%" . $x_ID . "%'";

$result=mysql_query($query);

$row=mysql_fetch_array($result);

 

echo $row['Name'];

?>

 

This is only bringing up one result for me, and there's more records in the table which need to be displayed. It is showing the right record, just one of them rather than multiple. It could possibly be a result of the other SQL queries on this page, but from what I've posted here, is there a problem? I can post the full page if need be...It just gets a little complicated.

 

Thanks, and hope this makes sense.

[Tainted Kitten]

Never mind, got it!