Topic: Synchronize last_post

Is there an easy way (i.e. besides looping over ever user) to sync the last_post field for all users? I don't have much experience with queries, so I can't quite wrap my head around this one.

Re: Synchronize last_post

Assuming you use a version of MySQL that supports subselects:

update users set last_post = (select posted from posts where poster_id = order by posted desc limit 1)

Free PunBB Hosting - lots of mods, easy to customize