[meowmeow]

--------sorry for the cross posting but its quite urgent, maybe here someone can help me-------
the forum statistics in the index page give some info about the forum.
one thing i'd like to change is the "newest member"
form index.php i can see it is taken from these two queries:

PHP Code:

$members = ("SELECT COUNT(*) AS users, MAX(userid) AS max FROM " . TABLE_PREFIX . "user"); 

and 
$newuser = ("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid = $members[max]"); 


I want to modify it so that instead of taking the MAX(userid) it takes the MAX(joindate)

so I changed it to this:

PHP Code:

$members = ("SELECT COUNT(*) AS users, MAX(joindate) AS max FROM " . TABLE_PREFIX . "user"); 
and 
$newuser = ("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE joindate = $members[max]"); 


still it doesnt work!
when i tried these 2 queries on a test script it worked, but on the forum it didnt change.
I dont know when functions_databuild.php is called, so it could be that it just hasnt refreshed, otherwise i don't know what i'm doing wrong!