Percentage Problem

[rahaiffi]

I have a coding to count the percentage but it didnt working...Please Help me..

<?
$sql2= "SELECT * FROM hea_subjekgred WHERE sb_id='$idSB' ORDER BY sgr_min desc" ;
	$result2= mysql_query($sql2);
  ?>
  <table width="64%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="<?echo $tblBorder?>" class="Title">
  <tr>
    <td  align="center"><strong>Mark </strong></td>
    <td  align="center"><strong>GRED</strong></td>
    <td  align="center"><strong>POINT</strong></td>
    <td  align="center"><strong>NO STUDENT </strong></td>
    <td  align="center"><strong>PERCENTAGE</strong></td>
  </tr>


  <?

  $jum=0;
  while($rows2 = mysql_fetch_array($result2)) {

  $gred = $rows2['sgr_gred'];
  $sql="SELECT count(hea_ambilmain.sb_id) as bil FROM hea_ambilmain, perjanjian_main WHERE perjanjian_main.pjm_id=hea_ambilmain.pjm_id AND sb_id='$idSB' AND ps_id='$idPS' AND am_gred='$gred'";
  $result= mysql_query($sql) or die("$sql<BR>".mysql_error());
  $rows = mysql_fetch_array($result)

 ?>
 <tr>
<td align='center'><? echo $rows2['sgr_min'];?>-<? echo $rows2['sgr_max'];?>&nbsp;</td>
<td align='center'><? echo $rows2['sgr_gred'];?>&nbsp;</td>
<td align='center'><? echo $rows2['sgr_gpoint'];?>&nbsp;</td>
<td align='center'><? echo $rows['bil'];?>&nbsp;</td>
<td align='center'><? echo $percent;?>&nbsp;</td>
  </tr>
<? $jum = $jum + $rows['bil']; 
	 $percent=(($rows['bil']/$jum)*100);}?>
  <tr>

<td>&nbsp;</td>
<td>&nbsp;</td>
<td align='right'>JUMLAH&nbsp;</td>
<td align='center'><? echo $jum;?>&nbsp;</td>
<td>&nbsp;</td>
  </tr>
</table>

when a first row, $jum didnt count a whole total of number of student but the current total.HELP ME..How to make $jum count the total of number of wole student...

[wilku]

Maybe there is some "cleaner" solution, but what I think you have to do is to create another while loop with mysql_fetch_row just to sum all the bils. Then you can use [man]mysql_data_seek[/man] to rewind your results and display your table properly.
Alternatively you can ask mysql for the sum with a query.