Untitled

<html>
	<head>
<script src="js/jquery.min.js" type="text/javascript"></script>
<script src="js/highcharts.js" type="text/javascript"></script>
<script type="text/javascript">
	var chart1; // globally available
$(document).ready(function() {
      chart1 = new Highcharts.Chart({
         chart: {
            renderTo: 'container',
            type: 'column'
         },
         title: {
            text: 'Grafik PRESENSI SISWA '
         },
         xAxis: {
            categories: ['Sakit','Izin','Alpha']
         },
         yAxis: {
            title: {
               text: 'TOTAL'
            }
         },
              series:
            [
            <?php
        	include('config.php');
           $sql   = "SELECT a.nama_kelas,sum(b.ket='Sakit') as Sakit,sum(b.ket='Alpha') as Alpha,sum(b.ket='Izin') as Izin from absensi b,tb_kelas a where b.kd_kelas=a.kd_kelas group by a.nama_kelas";
            $query = mysql_query( $sql )  or die(mysql_error());
            while( $ret = mysql_fetch_array( $query ) ){
            	$merek=$ret['nama_kelas'];
                 $sql_jumlah   = "SELECT a.nama_kelas,sum(b.ket='Sakit') as Sakit,sum(b.ket='Alpha') as Alpha,sum(b.ket='Izin') as Izin from absensi b,tb_kelas a where b.kd_kelas=a.kd_kelas and a.nama_kelas='$merek' group by a.nama_kelas";
                 $query_jumlah = mysql_query( $sql_jumlah ) or die(mysql_error());
                 while( $data = mysql_fetch_array( $query_jumlah ) ){
                    $S = $data['Sakit'];
					$A = $data['Alpha'];
					$I = $data['Izin'];

                  }
                  ?>
                  {
                      name: '<?php echo $merek; ?>',
                      data: [<?php echo $S; ?>,<?php echo $I; ?>,<?php echo $A; ?>]

                  },

                  <?php } ?>
            ]
      });
   });
</script>
	</head>
	<body>
		<div id='container'></div>
	</body>
</html>