CREATING STICKY THREADs

[obrienkev]

Hi all,

I have created a guestbook where each persons message is shown. I have the messeges in descending order but I want the first two messages to remain at the top of the page.

How do I do this?

Thank you,

Kevin.

[TheDefender]

Add a column enum('n','y') called sticky. Do a select from the DB for all listings where sticky = 'y' and loop those. Then run a query to pull the rest of the listings.

(There are other ways I am sure, but off the cuff, this ishow I would probably pursue it.)

[Pests]

Im pretty sure you can rewrite that to use one query and do a GROUP BY sticky clause to put the stickys togeather at the top then in your code check to see if sticky is set so you can make it look different / ect.