Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $dino_iki = date('Y-m-d');
- // $dino_iki = "2019-10-11";
- $kode_poli = trim($_POST['KDPOLY']);
- $sql_antrian_cari = "SELECT * FROM no_antrian WHERE kd_poli='$kode_poli' AND date(tgl) ='$dino_iki'";
- $q_antrian = mysql_query($sql_antrian_cari) or die(mysql_error());
- $num = mysql_num_rows($q_antrian);
- $idxDaftar = getLastIDXDAFTAR();
- if($num > 0){
- $urutan = $num+1;
- $to_noAntrian = "INSERT INTO no_antrian SET kd_poli='$kode_poli', idxdaftar='$idxDaftar', no_urut='$urutan'";
- }else {
- $to_noAntrian = "INSERT INTO no_antrian SET kd_poli='$kode_poli', idxdaftar='$idxDaftar', no_urut='1'";
- }
- $q_antrian_insert = mysql_query($to_noAntrian)or die(mysql_error());
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement