How do stickies work?

[ted_chou12]

when ordering the rows in a table (mysql) how do stickies work? do you have to setup a new column for it? if so, how would you put it into the mysql order by query?
Thanks
Ted

[Hypnos]

There might be a way to do it in MySQL directly, but I would just make a column, then add it to your ORDER BY.

Numeric column with 1 on the "sticky". Everything else will be 0.

[Orio]

Create a is_sticky column, that will contain true/false (1/0).
Then in your display query, change the order by part to something like this:
[code]SELECT * ... ORDER BY is_sticky, date[/code]

Orio.