Adding Categories....table join?

Adding Categories....table join?

El Forum
Unregistered

02-09-2008, 10:28 AM

[eluser]Armchair Samurai[/eluser]
Probably something like this:

Code:
$this->db->select('x.*');

$this->db->join('articlecategories AS y', 'x.ID = y.articleID');

$this->db->join('categories AS z', 'y.CategoryID = z.ID');

$this->db->where('z.name', $this->uri->segment(2));

$query2 = $this->db->get('articles AS x');

Messages In This Thread

Adding Categories....table join? - by El Forum - 02-09-2008, 10:06 AM

Adding Categories....table join? - by El Forum - 02-09-2008, 10:28 AM

Adding Categories....table join? - by El Forum - 02-09-2008, 12:08 PM

Adding Categories....table join? - by El Forum - 02-09-2008, 09:58 PM

Adding Categories....table join? - by El Forum - 02-09-2008, 11:04 PM

Adding Categories....table join? - by El Forum - 02-09-2008, 11:32 PM

Adding Categories....table join? - by El Forum - 02-10-2008, 12:31 PM

Adding Categories....table join? - by El Forum - 02-10-2008, 07:17 PM

Adding Categories....table join? - by El Forum - 02-10-2008, 08:04 PM

Adding Categories....table join? - by El Forum - 02-10-2008, 08:15 PM

Adding Categories....table join? - by El Forum - 02-10-2008, 08:30 PM

Adding Categories....table join? - by El Forum - 02-10-2008, 09:39 PM