Contoh kasus ada masalah seperti ini :
Query: SELECT d.departemen, d.nama, d.keterangan, d.ts, tb.replid FROM datava d LEFT JOIN tahunbuku tb on d.departemen = tb.departemen WHERE d.replid = '15'
ErrNo: 3477
Error: Data cannot be found
Solusi :
$sqldep = "SELECT nominal, transaksikey, info1, info3 FROM deposit WHERE replid='$iddeposit'";
$resultdep = QueryDb($sqldep);
if (is_null($resultdep)) {
} else {
while($rowdep = mysql_fetch_array($resultdep)) {
$deposit = $rowdep[0];
$transaksikey = $rowdep[1];
$idva = $rowdep[2];
$sisadep = $rowdep[3];
$selisih = $deposit - $sisadep;
}
}
Sekian dan terima kasih. Haha
Post a Comment