// ambil data koneksi dari file koneksi.inc.php
require("connect.inc.php");
$query = "select reg_kk,nama_kk from kk_saham where reg_kk='".$_GET[a]."'";
// jalankan perintah SQL untuk query
$hasil = mysql_db_query($db, $query, $koneksi) or
die("Kesalahan pada query!");
list($reg_kk,$nama_kk) = mysql_fetch_row($hasil);
?>
Anggota KK
| ANGGOTA KK |
| No |
Tgl_saham |
Nama |
Kelompok |
Jml |
Rp Saham |
$q_kat = "SELECT reg_kk,tgl_saham,nama,klp,jml_saham,rp_saham FROM master_saham where reg_kk='$reg_kk'" ;
$hasil_kat = mysql_db_query($db, $q_kat, $koneksi) or
die("Kesalahan pada query!");
//$num_rows = mysql_num_rows($hasil_kat);
//echo $q_kat;
$no=1;
while (list($reg_kk,$tgl_saham,$nama,$klp,$jml_saham,$rp_saham,$seri) = mysql_fetch_row($hasil_kat))
{
$q = "SELECT nama_kk FROM kk_saham where reg_kk ='".$reg_kk."' " ;
$hasil_q = mysql_db_query($db, $q, $koneksi) or
die("Kesalahan pada query!");
list($nama_kk) = mysql_fetch_row($hasil_q);
?>
|
|
|
$q_klp = "SELECT id,nama_klp FROM Kelompok where id=$klp" ;
$hasil_klp = mysql_db_query($db, $q_klp, $koneksi) or
die("Kesalahan pada query!");
list($id,$nama_klp) = mysql_fetch_row($hasil_klp);
echo stripslashes($nama_klp);?> |
|
|
$no++;
$tot = $tot + $jml_saham;
$tot_rp = $tot_rp + $rp_saham;
}
//echo $tot;
?>
| Jumlah Total |
|
|