[fla5h]

mmm am I a little out of my depth here ??

The script above gives stats of

Page generated in 15.43927801 seconds (1.93% PHP - 98.07% MySQL) with 78 queries.

However if I alter the script slightly,

PHP Code:

<?php

require('./global.php');


$q1="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";
$r1=mysql_query($q1);


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

    $q2="select count(*) from thread where postuserid=$bob[userid]";
    $r2=mysql_query($q2);
    $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);


    while($bill=mysql_fetch_array($r2))  {
   eval("\$memberdeets .= \"".gettemplate("memberdeets")."\";");  

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



?>

The stats show as

Page generated in 3.41518295 seconds (97.98% PHP - 2.02% MySQL) with 8 queries.

I still only get the first 50 odd member results, but I guess the second query is better ? Less queries more php ?

Am I correct here ?