MySQL loop into array question.

[savagenoob]

I have a script that displays a certain result set, the row I am concerned about is called 'endonum'. Some rows will have the same number in this field. Is there a way to only show 1 result with the same number in this field. The array will be like '1, 2, 3, 3, 4, 4, 4, 4, 5, 5, 5' and so on, but I just want to display 1 of them, not all. Kinda confusing but maybe someone gets it. Here is the code.

<?php
$selectendo = mysql_query("SELECT * FROM endorse WHERE agency = '$agency' AND finalized = 'No'")or die(mysql_error());
while($showendo = mysql_fetch_array($selectendo))
{
    $endonumber = $showendo['endonum'];
?>
<li><a href="viewendo.php?endonum=<?php echo $endonumber;?>">Endorsement Number:<?php echo $endonumber . " Date: " . $showendo['date'];?></a></li>  
<?php   
}
?>

 

[PFMaBiSmAd]

Are the $showendo['date'] vales the same when 'endonum' has the same value or what do you want to use for $showendo['date'] when you have several 'endonum' with the same value?

[savagenoob]

Yeah the date on all of them will be identical as well.

[PFMaBiSmAd]

Using DISTINCT in the query would probably solve it. It removes duplicate rows from the result set. You would need to select only those columns you need, rather than *

[savagenoob]

Oh, thats sweet. You da man... Thanks