scrip

<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());
$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 $ratasoal -> 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;
?>