cekidot

$sql=mysql_query("SELECT * FROM pemesanan
LEFT JOIN log_deposit_agen ON log_deposit_agen.id_pemesanan=pemesanan.id_pemesanan
LEFT JOIN gagal_transaksi ON gagal_transaksi.id_pemesanan=pemesanan.id_pemesanan
WHERE id_gagal IS NULL AND exp<=NOW() AND id_pemesan_online='0' AND id_log_deposit IS NULL ") ;
if($sql){
while($data=mysql_fetch_array($sql)){
    error_log(date("y-m-d H:i:s")."data:".json_encode($data)."\n",3,'gun.log');
    $total_kursi=$data['anak']+$data['dewasa'];
    $id_jadwal=$data['id_jadwal'];
    $id_pemesanan=$data['id_pemesanan'];
    $restore_kursi=mysql_query("UPDATE jadwal SET sisa_kursi=sisa_kursi +$total_kursi WHERE id_jadwal='$id_jadwal'");
//========CHECK THIS
    $log=mysql_query("INSERT INTO gagal_transaksi VALUE ('','$id_pemesanan')");
/*
VALUES bukan VALUE
*/
    echo $id_jadwal.$id_pemesanan.$total_kursi;
}
}else{
    error_log(date("y-m-d H:i:s")." gagal query:".mysql_error()."\n",3,'gun.log');

}