JOIN LIKE

[eluser]sloth[/eluser]
Salam...

Another newbie question :
i want to create an sql like this with active record :

SELECT * FROM "m_kkab"
JOIN "m_propinsi" ON "m_propinsi"."mp_nama" LIKE '%S%'
WHERE "m_kkab"."mkkab_nama" LIKE '%S%'

this is an active record i create :

Code:

$this->db->select('*');
$this->db->from('m_kkab');
$this->db->join('m_propinsi', "m_propinsi.mp_nama like '%$nmProv%'");
$this->db->like('m_kkab.mkkab_nama', $nmCity);
$this->db->limit($num,$offset);
$query = $this->db->get();  
return $query->result();

but it produce :
SELECT * FROM "m_kkab"
JOIN "m_propinsi" ON "m_propinsi"."mp_nama" "like" '%S%'
WHERE "m_kkab"."mkkab_nama" LIKE '%S%'

anyone can help me..?!?

[eluser]rogierb[/eluser]
Joins will always be escaped. Try rewriting your query or don't use active record.

An option might be

Code:

$this->db->select('*');
$this->db->from('m_kkab');
$this->db->join('m_propinsi', "m_propinsi.mp_nama = 'm_kkab.mkkab_nama'");
$this->db->like('m_kkab.mkkab_nama', $nmCity);
$this->db->limit($num,$offset);
$query = $this->db->get();  
return $query->result();

Although not the same as yours.

[eluser]sloth[/eluser]
Thank's.. It works..