Jump to content

Help grabbing other posts from a DISTINCT query


runnerjp

Recommended Posts

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);

 

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.