<? 
 $sirano = 1;
$query="SELECT username, SUM(matnet) FROM sonuc GROUP BY username ORDER BY SUM(matnet) desc LIMIT 0,100";  
$result = mysql_query($query) or die(mysql_error()); 

?> 

<table width="300" border="1"  bordercolor="#FFFFFF" bordercolordark="#FFFFFF" bordercolorlight="#FFFFFF" id="rounded-corner" summary="2007 Major IT Companies' Profit"> 
    <thead> 
        <tr> 
            <th width="10"  class="rounded-company" scope="col">No</th> 

            <th width="63"  class="rounded-company" scope="col">Kullanici Adi</th> 
            <th width="259"  class="rounded-q4" scope="col">Net</th>  </tr>   
            </thead> 
            <tfoot> 
            </tfoot> 
            <tbody> 
              
            <? 
             
            // Print out result 
while($row = mysql_fetch_array($result)){ 
?> 
    <tr> 
     <td><? echo $sirano; ?></td> 

      <td><? echo $row['username']; ?></td> 
      <td><? echo $row['SUM(matnet)']; ?></td></tr> 
   
<? 
  $sirano++;} 
?> 

</tbody> 
</table>