+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: [HELP] can't retrive a value (/showthread.php?tid=53160)
[HELP] can't retrive a value - El Forum - 07-12-2012
[eluser]C_Line[/eluser]
Code:
Controller
if($this->Query_barang->cek_supplier($value) == "FALSE" or $this->Query_barang->cek_supplier($value) == NULL)
{
echo "[removed]";
echo "alert('Tidak ada supplier lain yang tersedia')";
echo "[removed]";
}
Model
function cek_supplier($value)
{
$amb_idbrg = $this->db->query("Select * from barang where nama_barang = '$value'")->result();
foreach($amb_idbrg as $isi)
{
$id_brg = $isi->id_barang;
}
$amb_idsup = $this->db->query("Select id_supplier from barang_supplier where id_barang = '$id_brg'");
if($amb_idsup->num_rows < 1 or $amb_idsup->num_rows == 0 or $amb_idsup->num_rows < 0)
{
return FALSE;
}else{
return TRUE;
}
}why it can't return False if the row is NULL or < 1 || < 0
thx
[HELP] can't retrive a value - El Forum - 07-12-2012
[eluser]Aken[/eluser]
num_rows() is a function, not a property. And you only need the first check - the other two are redundant.
Code:
if ($amb_idsup->num_rows() < 1)