runnerjp Posted July 21, 2009 Share Posted July 21, 2009 im trying to pull from the db posts a user has made so that i can display there last 5 posts.. <?php $sql = "Select * FROM forumtutorial_posts where author = '$profilename' ORDER BY `showtime` DESC LIMIT 0, 5"; $postsresult = mysql_query($sql) or die("Could not get threads"); $num = mysql_num_rows($postsresult);if($num < 1) {echo 'User has yet to make a post.';}else{ while($row = mysql_fetch_assoc($postsresult)) { echo ' <a id="posts" href="http://www.runningprofiles.com/members/index.php?page=message&forum='.$row['forum'].'&id='.$row['postid'].'&pagenum=last">'.$row['title'].'</a> <br />' ;} }?> but say i posted under this 5 times it would show this only show db output once only show db output once only show db output once only show db output once only show db output once how can i only show it once per topic? Link to comment https://forums.phpfreaks.com/topic/166818-solved-only-show-db-output-once/ Share on other sites More sharing options...
Maq Posted July 21, 2009 Share Posted July 21, 2009 Do a DISTINCT on the topic. Link to comment https://forums.phpfreaks.com/topic/166818-solved-only-show-db-output-once/#findComment-879655 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.