<?php
//query kelurahan
$query_depan2="SELECT SUM(IF(pendidikan_ibu='pakis',1,0)) AS jml_pakis, 
SUM(IF(pendidikan_ibu='Sobo',1,0)) AS jml_sobo,
SUM(IF(pendidikan_ibu='kebalenan',1,0)) AS jml_kebalenan,
SUM(IF(pendidikan_ibu='sumberrejo',1,0)) AS jml_sumberrejo,
SUM(IF(pendidikan_ibu='tamanbaru',1,0)) AS jml_tamanbaru,
SUM(IF(pendidikan_ibu='tukangkayu',1,0)) AS jml_tukangkayu,
SUM(IF(pendidikan_ibu='kertosari',1,0)) AS jml_kertosari,
SUM(IF(pendidikan_ibu='penganjuran',1,0)) AS jml_penganjuran,
SUM(IF(pendidikan_ibu='panderejo',1,0)) AS jml_panderejo,
SUM(IF(pendidikan_ibu='temenggungan',1,0)) AS jml_temenggungan,
SUM(IF(pendidikan_ibu='kepatihan',1,0)) AS jml_kepatihan,
SUM(IF(pendidikan_ibu='kampung melayu',1,0)) AS jml_kmpmelayu,
SUM(IF(pendidikan_ibu='kampung mandar',1,0)) AS jml_kmpmandar,
SUM(IF(pendidikan_ibu='singonegaran',1,0)) AS jml_singonegaran,
SUM(IF(pendidikan_ibu='singotrunan',1,0)) AS jml_singotrunan,
SUM(IF(pendidikan_ibu='pengantigan',1,0)) AS jml_pengantigan,
SUM(IF(pendidikan_ibu='lateng',1,0)) AS jml_lateng,
SUM(IF(pendidikan_ibu='karangrejo',1,0)) AS jml_karangrejo,


SUM(IF(status_pendaftaran='Belum Diverifikasi',1,0)) AS jml_verifikasi, SUM(IF(status_pendaftaran='Tidak Diterima',1,0)) AS jml_ditolak  from ro_formulir";
$perintah=mysqli_query($koneksi,$query_depan2);
$data2=mysqli_fetch_array($perintah);
//query tamu

?>