code spagety

<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;
}


require_once('include/koneksi.php');
$query1="select * from users limit $posisi, $batas ";
//$ratasoal ="(SELECT ((sum(col6) + sum(col7) +sum(col7) + sum(col8) + sum(col9) + sum(col10) + sum(col11) + sum(col12) + sum(col13))/count(*)) FROM users)";
//$ratasoal ="SELECT avg(soal1 + soal2 + soal3 + soal4 + soal5 + soal6 + soal7 + soal8 + soal9) as avgtotal
FROM users";
$ratasoal =mysql_query("SELECT soal1,soal2,soal3,soal4,soal5,soal6,soal7,soal8,soal9, (soal1 + soal2 + soal3 +
soal4 + soal5 + soal6 + soal7 + soal8 + soal9)/9  as avgtotal FROM users");
//$ratasoal ="SELECT (soal1 + soal2 + soal3 + soal4 + soal5 + soal6 + soal7 + soal8 + soal9)/9  as avgtotal FROM users";

//$ratasoal ="SELECT sum(soal1,soal2,soal3,soal4,soal5,soal6,soal7,soal8,soal9) as avgtotal FROM users";
//$ratasoal ="SELECT AVG(soal1)  as avgtotal FROM users";

$result=mysql_query($query1) or die(mysql_error());
//====query jalanin select * from users limit $posisi, $batas
//====== yang mau di jalanin bukannya $ratasoal ??
$no=1; //penomoran

while($rows=mysql_fetch_object($result)){
?>
     <tr>var_dump($rows);
     <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>

<?php
    //=============PAGING ========================
            $sql_paging = mysql_query("select username  from users");
            $jmldata = mysql_num_rows($sql_paging);
            $jumlah_halaman = ceil($jmldata / $batas);

            echo "<br>Halaman :";
            for($i = 1; $i <= $jumlah_halaman; $i++)
                if($i != $halaman) {
                    echo "<a href=query42.php?halaman=$i>$i</a>|";
                } else {
                    echo "<b>$i</b>|";
                }
            mysql_close();?>
        <br>
        Jumlah data :<?php echo $jmldata;
?>