runnerjp Posted June 15, 2010 Share Posted June 15, 2010 How can i get the forum and postid from the above query as it wont let me due to it being distinct but i need it to be distinct so i dont pick up replys. $sql = "Select DISTINCT title 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); Link to comment https://forums.phpfreaks.com/topic/204841-help-grabbing-other-posts-from-a-distinct-query/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.