[cirisme]

$dposteurs=$DB_site->query_first("SELECT post.dateline AS lastpostminute, thread.threadid, user.username, user.userid
FROM post, thread
LEFT JOIN user ON user.userid = post.userid
WHERE thread.forumid = $forumid AND thread.threadid = post.threadid
ORDER BY post.dateline DESC
LIMIT 1");

SHOULD do it(hopefully). And then use $dposteurs[userid]. But let me go test it.

Edit:

Okay, looks good. Thanks! :banana: