[eluser]kodkanyon[/eluser]
Hello,
I don't have a problem when i use id IN ('.$id.') in a SQL sentence but whenever i use (?) there is a problem.
It works::
models:
function query($sql,$array){
$query = $this->db->query($sql,$array);
return $query->result($array);
}
controllers:
$this->MGenel->query('SELECT * FROM bloklar WHERE dil = ? AND id IN ('.$id.') ORDER BY agirlik', $this->session->userdata('dil'));
output with last_query:
SELECT adi,dosya_yolu,icerik,agirlik FROM bloklar WHERE gosterim="aktif" AND dil = 'tr' AND id IN (1,2) ORDER BY agirlik
When it doesn't work:
controllers:
$this->MGenel->query('SELECT adi,dosya_yolu,icerik,agirlik FROM bloklar WHERE gosterim="aktif" AND dil = ? AND id IN (?) ORDER BY agirlik', $id, $this->session->userdata('dil'));
Error Msg:
Fatal error: Call to a member function result() on a non-object in
Thanks for your help.