PHP - +rep (when I can)

[Hitman]

Hi.

How could I implement something, where if the topic has a new reply it's sent to the top?

I was thinking have numbers in the topic table, and change when a new reply is made but I don't think it'll be easy to just update every thread.

So, how could I do this?

TY. +rep if and when I can, I'll add you to sig.

[MrCraig]

Use a timestamp and in your query order them descending?
(Update the timestamp every time a new message is posted)

Thats the way i do it..

[Hitman]

Good idea, I will try. Thanks.

[Jamie.]

i would just sort id to descending..... :S
Timestamp will work otherwise.