[Electronic Punk]

Actually inserting it into a php script so I can run it every now and then as more old users return 9(tho I reckon that could also be done manually as it willb e fairly infrequently)

<?php
mysql_connect("localhost", "username", "password");
mysql_select_db("osnn");

$users = mysql_query("SELECT userid,joindate FROM user");
while($user = mysql_fetch_array($users))
{
$post = mysql_query("SELECT * FROM post WHERE post.userid='90' ORDER BY dateline ASC LIMIT 1");

if($post['dateline'] < $user['joindate'])
{
mysql_query("UPDATE user SET joindate='$post[dateline]' WHERE userid='90'");
}
}

?>

http://forum.osnn.net/member.php?u=90
Geffy is my test user.
His join date in the database is now 0 so shows the earliest possible date.

I really appreciate your help so far! I can't write SQL commands, but can kinda read them and as far as I can tell looks right, but I don't know