• Registered: 2006-06-05
  • Posts: 410

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.

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

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 = users.id order by posted desc limit 1)