View difference between Paste ID: pZ2m50QE and F3i2YSXf

 <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) +
+//$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
-sum(col12) + sum(col13))/count(*)) 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";
-//$ratasoal ="SELECT (soal1 + soal2 + soal3 + soal4 + soal5 + soal6 + soal7 + soal8 + soal9)/9  as avgtotal
+
 $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>
-<tr>var_dump($rows);
+     <td><?php echo $rows->avgtotal;?></td>
-<td><?php echo $no ?></td>
+     <td><?php echo $rows->waktu1;?></td>
-<td><?php echo $rows -> username;?></td>
+     <td align='right'><?php
-<td><?php echo $ratasoal -> avgtotal;?></td>
+echo $rows->petunjuk1;?></td>
-<td><?php echo $rows -> waktu1;?></td>
+     </tr>
-<td align='right'><?php	echo $rows -> petunjuk1;?></td>
+
-</tr>
+
 $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;
 ?>