[fla5h]

sure thanks for the help, I cannot see a loop to be stuck in, but I know nothing compared to you

PHP Code:

<?php

require('./global.php');

$r1=$DB_site->query("SELECT user.userid, user.username, user.joindate, user.posts, user.lastactivity, 

post.dateline, 

post.threadid,
usergroup.title, thread.title as ptitle
FROM user,post,usergroup,thread
WHERE user.lastpost=post.dateline AND user.usergroupid=usergroup.usergroupid AND 

post.threadid=thread.threadid
ORDER BY usergroup.title,user.username");



    while($bob=mysql_fetch_array($r1))
{


    $q2=$DB_site->query_first("select count(*) as postuserid from thread where 

postuserid=$bob[userid]");
    $threads=$q2[postuserid];
    $ld=$bob[dateline];
    $ld2=date("d/m/y (G:i)",$ld);
    $lv=$bob[lastactivity];
    $lv2=date("d/m/y (G:i)",$lv);
    $jd=$bob[joindate];
    $jd2=date("d/m/y (G:i)",$jd);

    eval("\$memberdeets .= \"".gettemplate("memberdeets")."\";");    



}

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

?>

This will show the following stats

Username
Usertitle ( not custom title )
Posts
Threads
Last Post ( both Date / Time and thread id )
Last visit Date / Time
Joined Date / Time

I am going to add a few more, but before I do I cannot understand why it stops at 50 odd members.

Would it help if I adopted the VB style where the number of results a page is used ?

Ie only 30 per page ?

Thanks for any help given