Rekapan Saham Perkelompok

> > > >  s/d Bln  > > > >

='".$tanggal_jual."' and tgl_saham<='".$tanggal_jual_max."' and klp='MENTAWAI' "; $hasil_mt = mysql_db_query($db, $query_mt, $koneksi) or die("Kesalahan pada query!"); list($saham_mt) = mysql_fetch_row($hasil_mt); $query_wn = "SELECT sum(rp_saham) saham_wn FROM master_saham WHERE tgl_saham>='".$tanggal_jual."' and tgl_saham<='".$tanggal_jual_max."' and klp='WINONGO' "; $hasil_wn = mysql_db_query($db, $query_wn, $koneksi) or die("Kesalahan pada query!"); list($saham_wn) = mysql_fetch_row($hasil_wn); $query_srk = "SELECT sum(rp_saham) saham_srk FROM master_saham WHERE tgl_saham>='".$tanggal_jual."' and tgl_saham<='".$tanggal_jual_max."' and klp='SYAREKAH' "; $hasil_srk = mysql_db_query($db, $query_srk, $koneksi) or die("Kesalahan pada query!"); list($saham_srk) = mysql_fetch_row($hasil_srk); $query_kr = "SELECT sum(rp_saham) saham_kr FROM master_saham WHERE tgl_saham>='".$tanggal_jual."' and tgl_saham<='".$tanggal_jual_max."' and klp='KARANGANYAR' "; $hasil_kr = mysql_db_query($db, $query_kr, $koneksi) or die("Kesalahan pada query!"); list($saham_kr) = mysql_fetch_row($hasil_kr); $query_jw = "SELECT sum(rp_saham) saham_jw FROM master_saham WHERE tgl_saham>='".$tanggal_jual."' and tgl_saham<='".$tanggal_jual_max."' and klp='JIWAN' "; $hasil_jw = mysql_db_query($db, $query_jw, $koneksi) or die("Kesalahan pada query!"); list($saham_jw) = mysql_fetch_row($hasil_jw); //echo $query_jw; $query_ka = "SELECT sum(rp_saham) saham_ka FROM master_saham WHERE tgl_saham>='".$tanggal_jual."' and tgl_saham<='".$tanggal_jual_max."' and klp='KEBONAGUNG' "; $hasil_ka = mysql_db_query($db, $query_ka, $koneksi) or die("Kesalahan pada query!"); list($saham_ka) = mysql_fetch_row($hasil_ka); $query_ng = "SELECT sum(rp_saham) saham_ng FROM master_saham WHERE tgl_saham>='".$tanggal_jual."' and tgl_saham<='".$tanggal_jual_max."' and klp='NGAMPEL' "; $hasil_ng = mysql_db_query($db, $query_ng, $koneksi) or die("Kesalahan pada query!"); list($saham_ng) = mysql_fetch_row($hasil_ng); $query_ra = "SELECT sum(rp_saham) saham_ra FROM master_saham WHERE tgl_saham>='".$tanggal_jual."' and tgl_saham<='".$tanggal_jual_max."' and klp='RANDUALAS' "; $hasil_ra = mysql_db_query($db, $query_ra, $koneksi) or die("Kesalahan pada query!"); list($saham_ra) = mysql_fetch_row($hasil_ra); $query_ll = "SELECT sum(rp_saham) saham_ll FROM master_saham WHERE tgl_saham>='".$tanggal_jual."' and tgl_saham<='".$tanggal_jual_max."' and klp<>'MENTAWAI' and klp<>'SYAREKAH' and klp<>'WINONGO' and klp<>'KARANGANYAR' and klp<>'JIWAN' and klp<>'KEBONAGUNG' and klp<>'RANDUALAS' and klp<>'NGAMPEL'"; $hasil_ll = mysql_db_query($db, $query_ll, $koneksi) or die("Kesalahan pada query!"); list($saham_ll) = mysql_fetch_row($hasil_ll); $total_klp=$saham_mt+$saham_srk+$saham_wn+$saham_ka+$saham_ng+$saham_jw+$saham_ra+$saham_kr+$saham_ll; ?>

No	Kelompok	Jumlah Saham
1	Mentawai
2	Winongo
3	Bina Syarekah
4	Karang Anyar
5	Jiwan
6	Kebonagung
7	Ngampel
8	Randualas
9	Lain - Lain
Total