CodeIgniter Forums

Full Version: [HELP] can't retrive a value
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[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

El Forum

[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)