[-NM-]

Okay, in the forum i am building, it displays threads by ordering them by the last reply:

PHP Code:

$threaddata = "SELECT * FROM `threads`WHERE forum_id='$forum_id' ORDER BY  `threads`.`thread_last_reply`DESC";

$threadresult = mysql_query($threaddata, $dbc); 

But some threads are pinned, and i want them to always stay at the top, regardless of their last reply. So how would i go about this?

Would i have to create two different sections? The first one for all the pinned threads and the 2nd for all the rest? Or is there some way to tell it to always have them at the top?

Thanks.

[job0107]

Maybe like this:

PHP Code:

<?php
$threaddata = "SELECT * FROM threads WHERE forum_id='$forum_id' ORDER BY  threads.pinned ASC, threads.thread_last_reply DESC";
?>

[kjarli]

You should first check if there ARE pinned threads. If not, just load the threads, if there are, load them first.

[job0107]

My query will sort them and always have the pinned ones on top.
You just need to print them out.

[-NM-]

Originally Posted by job0107

Maybe like this:

PHP Code:

<?php
$threaddata = "SELECT * FROM threads WHERE forum_id='$forum_id' ORDER BY  threads.pinned DESC, threads.thread_last_reply DESC";
?>

Yes that worked, thank you.

[kjarli]

K, nice ill safe it since im building a forum too

Depends on what the values of pinned is (in my case tinyint[1]), so i have to use the DESC like you said, though when you use something like enum ('yes', 'no'), you have to watch the Y and N

[job0107]

Originally Posted by -NM-

Yes that worked, thank you.

Your welcome. My pleasure.

Cheers...