Jump to content

[SOLVED] displaying topics in order


runnerjp

Recommended Posts

currently i try and order my posts like so

 

$getthreads="Select * from forumtutorial_posts where parentid='0' and forum = '$forum' ORDER BY important ASC, lastrepliedto DESC $max";

 

what i have done is where i want a topic to be sticky (like on here but mines called important) that its 1st in the orfer of topics then under it follows the lastreplies to the newest on top..

 

$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;

 

but the thing is it puts it in any random order :S

Link to comment
https://forums.phpfreaks.com/topic/112006-solved-displaying-topics-in-order/
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.