require("connect.inc.php"); ?>
UPDATE CADANGAN MODAL PER PERIODE
TAHUN
$q_smt = "SELECT semester,tgl_awal,tgl_semester FROM deviden order by tgl_awal" ; $hasil_smt = mysql_db_query($db, $q_smt, $koneksi) or die("Kesalahan pada query!"); while (list($semester,$tgl_awal,$tgl_semester) = mysql_fetch_row($hasil_smt)) { ?>
" >
Periode
>Semua periode $q_periode = "SELECT id,nama_periode FROM periode order by nama_periode " ; $hasil_periode = mysql_db_query($db, $q_periode, $koneksi) or die("Kesalahan pada query!"); while (list($id,$nama_periode) = mysql_fetch_row($hasil_periode)) { ?>
>
if (!$_POST[tambah]) { } else { $periode = $_POST[periode]; $semester_form = $_POST[semester_form]; $tgl_smt = substr(strstr($semester_form,"@"),1,10); $tgl_awal = substr($semester_form,0,strpos($semester_form,"@")); $query1 = "select per_rupiah from deviden where tgl_awal ='".$tgl_awal."' and tgl_semester ='".$tgl_smt."'"; //echo $query1; $hasil1 = mysql_db_query($db, $query1, $koneksi) or die("Kesalahan pada query!"); list($per_rupiah) = mysql_fetch_row($hasil1); //echo $per_rupiah; $query = "Update shu_saham set nilai_deviden = nilai_deviden+(rupiah_saham*".$per_rupiah.") where tgl_saham<='".$tgl_smt."' and laba_semester='".$periode."'"; $hasil = mysql_db_query($db,$query,$koneksi) or die('Kesalahan pada proses query!'); echo "
Update Sukses
".$semester_form; //echo $query; //echo '
'; // $i++; //} } ?>