require("connect.inc.php"); ?>
Update Nomor Register Saham
Semester
:
$q_smt = "SELECT semester,tgl_awal,tgl_semester FROM deviden " ; $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)) { ?>
" >
if (!$tambah) { } else { $tgl_smt = substr(strstr($semester_form,"@"),1,10); $tgl_awal = substr($semester_form,0,strpos($semester_form,"@")); $query1 = "select sum(per_rupiah) per_1 from deviden where tgl_semester >='".$tgl_smt."'"; $hasil1 = mysql_db_query($db, $query1, $koneksi) or die("Kesalahan pada query!"); list($per_1) = mysql_fetch_row($hasil1); $query = "Update shu_saham set nilai_deviden = rupiah_saham*".$per_1." where tgl_saham>='".$tgl_awal."' and tgl_saham<='".$tgl_smt."'"; $hasil = mysql_db_query($db,$query,$koneksi) or die('Kesalahan pada proses query!'); echo "
Update Sukses
"; //echo $query; //echo '
'; // $i++; //} } ?>