Make it so when someone replies to topic it goes to top

[Xyphon]

I'm making forums, how do I make it so when someone replies to a topic, it goes to the top of the page?

I know it's a simple question, I want a simple answer.

[mraza]

you can add one date column in your replies table, and sort them by date

[Xyphon]

you can add one date column in your replies table, and sort them by date

Yeah, in my date column its set up as Y-m-d, but how do I order them by it? That's the confusing part.

[GoneNowBye]

instead of y-m-d or whatever

use an integer colomn and put the time() value into

the number of seconds since the unix epoch - the first second of 1970.

 

then just "order by `last_post` desc"

 

 

[ignace]

instead of y-m-d or whatever

use an integer colomn and put the time() value into

the number of seconds since the unix epoch - the first second of 1970.

 

then just "order by `last_post` desc"

 

 

 

And that doesn't work with a DATETIME column, because?