Jump to content

[SOLVED] only show db output once


runnerjp

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.