[rake]

sorry about that. i didn't test the code and i also had one of the fields wrong (mentioned that in the post above).

try this but test it first.

$users = $DB_site->query("SELECT userid,joindate FROM user");
while($user = $DB_site->fetch_array($users))
{
$post = $DB_site->query_first("SELECT * FROM post WHERE postuserid='$user[userid]' ORDER BY dateline ASC LIMIT 1");

if($post['dateline'] < $user['joindate'])
{
$DB_site->query("UPDATE user SET joindate='$post[dateline]' WHERE userid='$user[userid]'");
}

}