newbie help - limit duplicate rows displaying

[replaya]

At the moment my script echo the dates as a link to show when the users entered their details.

2006-12-04
2006-12-08
2006-12-08
2006-12-08

What I am trying to do is just display the dates that are different so it only shows 2006-12-04 and 2006-12-08. So when a person click on the 2006-12-04 it will output all the users who entered their details for that date and same with 2006-12-08.

Your help is much appreciated

[code]
<?php
include ($_SERVER['DOCUMENT_ROOT'].'conn.inc.php');

mysql_select_db("mydatabase");


$query = "SELECT client_added FROM client_information ORDER BY client_added";


$results = mysql_query($query)
or die (mysql_error());
?>
<table width="300">
<?php
while ($row = mysql_fetch_assoc($results)) {
extract($row);

echo "<a href=\"newuser.php?client_id=" .$client_added ."\">";
echo $client_added;
echo "</a>";
echo '<br />';
}
?>
</table>


[/code]

[ToonMariner]

$query = "SELECT DISTINCT client_added FROM client_information ORDER BY client_added";

[replaya]

Oh brilliant - thankyou

:)