How to do sticky threads in forums?

[Anon]

Hi!

I'm building a forum from scratch and I just got to the point where I want to make it possible to make a thread sticky. But I don't know how to do it properly/logically.

In the database each post has a colom for 'sticky' 1 or 0. And when the forum lists new topics it first checks all post where 'sticky = 1' and echoes them out. Then it takes all posts where 'sticky = 0'. This works well. But I can't figure out what to do when a user hits page 2+.

Should I check wether 2+ is active before echoing sticky posts? What then, if the whole first page (plus more eventually) is made of sticky posts?

I know this might be a bit far fetched but it's an interesting problem. Well, at least I think so =)

Any suggestions?

Btw. I did try searching for the problem but never found anything related =(

Regs.
Summer

[Anon]

Why not do a single db query for all the data and then order the data by sticky DESC... Then when you display, check if the sticky bit is set and display it as a sticky thread... otherwise display it as a normal thread.

-Josh B

[Anon]

HA! thanks a bunch!!! man, of course why didn't I think of that ? you're my hero for a day =)

Regards
Summer