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? Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.