replaya Posted December 8, 2006 Share Posted December 8, 2006 At the moment my script echo the dates as a link to show when the users entered their details. 2006-12-042006-12-082006-12-082006-12-08What 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]<?phpinclude ($_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"><?phpwhile ($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] Quote Link to comment Share on other sites More sharing options...
ToonMariner Posted December 8, 2006 Share Posted December 8, 2006 $query = "SELECT DISTINCT client_added FROM client_information ORDER BY client_added"; Quote Link to comment Share on other sites More sharing options...
replaya Posted December 8, 2006 Author Share Posted December 8, 2006 Oh brilliant - thankyou :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.