ternyata kerapian itu perlu

<title>Query 4, menghitung rata-rata</title>
<h2>Query 4 Menghitung Rata-rata nilai dari Query Tabel Users</h2>
<style type="text/css">
table {
  font: 12px/24px Verdana, Arial, Helvetica, sans-serif;
  border-collapse: collapse;
  width: 500px;
  margin:0 auto;
}
th {
  border: 1px solid #CCC;
  padding: 0 0.5em;
  text-align: center;
  background-color:#00FF66
}
td {
  border: 1px solid #CCC;
  padding: 0 0.5em;
  background-color:#DFFDD5;
}
h1 {
  color:#003300;
  font:22px "Trebuchet MS";
  text-align:center;
}
</style>
<table border="1" width="500px">
<tr>
<th>No</th>
<th>Nama Anak</th>
<th>Rata-rata Skor</th>
<th>Rata-rata Waktu</th>
<th>Petunjuk</th>
</th>

<!-- example 1 :menampilkan data di tabel-->
<?php
error_reporting(E_ALL ^ (E_NOTICE | E_WARNING));
$batas=30; //satu halaman menampilkan 30 baris
$halaman=$_GET['halaman'];
$posisi=null;
if(empty($halaman)){
    $posisi=0;
    $halaman=1;
}else{
    $posisi=($halaman-1)* $batas;
}

//===============START HERE=================
require_once('include/koneksi.php');
$sql="SELECT soal1,soal2,soal3,soal4,soal5,soal6,soal7,soal8,soal9, (soal1 + soal2 + soal3 +
soal4 + soal5 + soal6 + soal7 + soal8 + soal9)/9  as avgtotal,
username, waktu1,petunjuk1
 FROM users";
$result=mysql_query($sql) or die(mysql_error());

$no=1; //penomoran

while($rows=mysql_fetch_object($result))
{
?>

     <td><?php echo $no; ?></td>
     <td><?php echo $rows->username;?></td>
     <td><?php echo $rows->avgtotal;?></td>
     <td><?php echo $rows->waktu1;?></td>
     <td align='right'><?php
echo $rows->petunjuk1;?></td>
     </tr>
<?php

$no++;
}
?>
</table>