07-03-2007, 03:40 PM
[eluser]cayasso[/eluser]
Is there a way to convert this query that are using two tables by using the Active Record Class
for example this code
can be replaced with this
where you don't need to add the SELECT because it does it automatically. but how to do this with 2 tables.
I am newbie so have patient.
Thanks in advance for your help.
Is there a way to convert this query that are using two tables by using the Active Record Class
Code:
$query = $this->db->query('SELECT * FROM lkx_text, lkx_page WHERE lkx_page.pg_id = '.$pdid.' AND lkx_text.pg_id = lkx_page.pg_id');
for example this code
Code:
$query = $this->db->query('SELECT * FROM table1 WHERE table1_id = '.$var_id);
can be replaced with this
Code:
$this->db->where('table1_id', $var_id);
$query = $this->db->get('table1');
where you don't need to add the SELECT because it does it automatically. but how to do this with 2 tables.
I am newbie so have patient.
Thanks in advance for your help.