I need help with syntax
Posted: Fri Nov 13, 2009 2:56 pm
I added an if else statement in my code to single out a user and the details of that user but it comes out giving my an unlimited number of results with everyone having that user name only but having the details of the first record in the query. I'm sure there is a better way to position the if else statement to do what I want but I'm having trouble figuring it out. I am posting the code below.
<?
$query = 'SELECT * , sum( points ) , count( week ) , min( points ) , max( points ) FROM `SeasonTotals` GROUP BY name ORDER BY `sum( points )` DESC ';
$result=mysql_query($query);
$fnum=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $fnum) {
//$st=0;
$p=$i-1;
$spleader=mysql_result($result,0,"sum( points )");
$rname=mysql_result($result,$i,"name");
$points=mysql_result($result,$i,"sum( points )");
$weeks=mysql_result($result,$i, "count( week )");
$min=mysql_result($result,$i, "min( points )");
$max=mysql_result($result,$i, "max( points )");
$pb=mysql_result($result,$p,"sum(points)");
$behind=$spleader-$points;
$extra=1 ;
$pos=$i+$extra ;
if ($rname="JG4TMR") {
?>
<tr>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$pos"; ?></font></b></td>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$rname"; ?></font></b></td>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$points"; ?></font></b></td>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$behind"; ?></font></b></td>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$weeks"; ?></font></b></td>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$min"; ?></font></b></td>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$max"; ?></font></b></td>
</tr>
<?
} else {
++$i;
}
}
echo "</table>";
?>
<?
$query = 'SELECT * , sum( points ) , count( week ) , min( points ) , max( points ) FROM `SeasonTotals` GROUP BY name ORDER BY `sum( points )` DESC ';
$result=mysql_query($query);
$fnum=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $fnum) {
//$st=0;
$p=$i-1;
$spleader=mysql_result($result,0,"sum( points )");
$rname=mysql_result($result,$i,"name");
$points=mysql_result($result,$i,"sum( points )");
$weeks=mysql_result($result,$i, "count( week )");
$min=mysql_result($result,$i, "min( points )");
$max=mysql_result($result,$i, "max( points )");
$pb=mysql_result($result,$p,"sum(points)");
$behind=$spleader-$points;
$extra=1 ;
$pos=$i+$extra ;
if ($rname="JG4TMR") {
?>
<tr>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$pos"; ?></font></b></td>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$rname"; ?></font></b></td>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$points"; ?></font></b></td>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$behind"; ?></font></b></td>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$weeks"; ?></font></b></td>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$min"; ?></font></b></td>
<td align="center"><b><font face="Arial, Helvetica, sans-serif"><? echo "$max"; ?></font></b></td>
</tr>
<?
} else {
++$i;
}
}
echo "</table>";
?>