runnerjp Posted June 26, 2008 Share Posted June 26, 2008 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 More sharing options...
ober Posted June 26, 2008 Share Posted June 26, 2008 What is in the field important? 1/0? We need a little more information. Link to comment https://forums.phpfreaks.com/topic/112006-solved-displaying-topics-in-order/#findComment-574988 Share on other sites More sharing options...
runnerjp Posted June 26, 2008 Author Share Posted June 26, 2008 the field important is indeed 1/0 ... i fixed it tho while waiting... was sum sql trouble with setting the default to 0 and i needed it to be 2 Link to comment https://forums.phpfreaks.com/topic/112006-solved-displaying-topics-in-order/#findComment-575002 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.