using sum in while

[DBallerz01]

$calcs = $db->sql_query("select crew_name, crew_id ,sum(user_power) as
sumpower, count(*) as numusers, sum(user_power) / count(*) as avgpowerfrom
nuke_users where user_crew = '$crew_name' ORDER BY numusers DESC LIMIT
0,5"); 

$queryResult = mysql_query($calcs); 
$row4 = mysql_fetch_assoc($queryResult); 

while(list($crew_id, $crew_name, $numusers) = sql_fetch_row($queryResult, $dbi))
{ 
                                                                $numusers = number_format($numusers); 
                $content .= "<b><font
color=\"$numtextcolor\">$topcrew.</font></b>&nbsp; <a
href=\"crewprofile.php?user_id=$user_id\">$username</a> <b>$numusers</b><br>
"; 
$topcrew++; 
} 
?> 

[Cam]

Umm, you don't provide any description for your code but let me have a stab and post back how it goes.

$sql = "select crew_name
            , crew_id
            , sum(user_power) as sumpower
            , count(*) as numusers
            , sum(user_power) / count(*) as avgpower
        from
            nuke_users
        where
            user_crew = '{$crew_name}'
        order by
            numusers desc
        limit 0, 5" ;
$rs = $db->sql_query($sql);

while ( $row = $db->sql_fetch_row($rs) ) {
    $numusers = number_format($row['numusers']);
    
    $content .= '<strong><span style="color: ' . $numtextcolor . ';">' . $topcrew . '</span></strong>
                 &nbsp;
                 <a href="crewprofile.php?user_id=' . $user_id . '">' . $username . '</a>
                 &nbsp;
                 <strong>' . $numusers . '</strong>' ;
    $topcrew++;
} 

You don't show us where any of the variables used within the loop come from and I don't know what you're trying to do (hint: it would be helpful if you told us!) but my guess is that it won't work the way you are trying.

[Cam]

This is what I think you're hopoing to achieve, correct me if I'm wrong though. At least a little closer...

$sql = "select crew_name
            , crew_id
            , sum(user_power) as sumpower
            , count(*) as numusers
            , sum(user_power) / count(*) as avgpower
        from
            nuke_users
        where
            user_crew = '{$crew_name}'
        order by
            sumpower desc
        limit 0, 5" ;
$rs = $db->sql_query($sql);

$rank = 0;
while ( $row = $db->sql_fetch_row($rs) ) {
    $numusers = number_format($row['numusers']);
    
    $content .= '<strong>' . $rank . '.</strong>
                 &nbsp;
                 <a href="crewprofile.php?user_id=' . $row['crew_id'] . '">' . $row['crew_name'] . '</a>
                 &nbsp;
                 <strong>' . $numusers . ' / ' . $row['sumpower'] . '</strong>' ;
    $rank++;
} 

[DBallerz01]

thanks, Ill try that

[DBallerz01]

i get the following error parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING'
on this line

<?php
 <a href="crewprofile.php?user_id=' . $row['crew_id'] . '">' . $row['crew_name'] . '</a> 
?>

[Chris82]

<?php 
   echo '<a href="crewprofile.php?user_id=' . $row['crew_id'] . '">' . $row['crew_name'] . '</a>';
  ?>

And about the query: You need a group by:

 $sql = "select crew_name 
  			, crew_id 
  			, sum(user_power) as sumpower 
  			, count(*) as numusers 
  			, sum(user_power) / count(*) as avgpower 
  		from 
  			nuke_users 
  		where 
  			user_crew = '{$crew_name}' 
  		order by 
  			sumpower desc 
   	    group by
   	            crew_name, crew_id
  		limit 0, 5" ;