need user details from thread table

[khaleejy]

hi


$topts=$DB_site->query("SELECT COUNT(threadid) AS threads, username, postuserid FROM thread LEFT JOIN user ON(user.userid=thread.postuserid) GROUP BY thread.postuserid ORDER BY threads DESC LIMIT 10");
$toptsbits = "";
$level=0;
while($topt=$DB_site->fetch_array($topts)) {
$level++;
$threadcount=$topt['threads'];
$topusername=$topt['username'];
$userid=$topt['postuserid'];
eval("\$toptsbits .= \"".gettemplate('forumhome_topts')."\";");
}
$DB_site->free_result($topts);


eval("dooutput(\"".gettemplate("top_threadstarter")."\");");


could any one moditfy my script so that i can get the user register date, user email , user last seen date??

[curley]

$threadcount=$topt['threads'];
$topusername=$topt['username'];
$userid=$topt['postuserid'];


i couldnt swear to it but i would say do this instead

$threadcount=$topt[threads];
$topusername=$topt[username];
$userid=$topt[postuserid];

[khaleejy]

theres nothing wronge with it.. its working fine

[Xenon]

change this:$topts=$DB_site->query("SELECT COUNT(threadid) AS threads, username, postuserid FROM thread LEFT JOIN user ON(user.userid=thread.postuserid) GROUP BY thread.postuserid ORDER BY threads DESC LIMIT 10");
into
$topts=$DB_site->query("SELECT COUNT(threadid) AS threads, user.username, user.lastvistit, user.lastactivity, user.joindate, postuserid FROM thread LEFT JOIN user ON(user.userid=thread.postuserid) GROUP BY thread.postuserid ORDER BY threads DESC LIMIT 10");

then you can use $topt[joindate] and so on

[khaleejy]

thanks alot :)