Welcome Guest, Not a member yet? Register   Sign In
Adding Categories....table join?
#1

[eluser]afterspark[/eluser]
Hello,

I'm trying to add categories to my database application. I already have the database structure set up like so....

articles
-ID
-Name

categories
-ID
-Name

articlecategories
-articleID
-CategoryID

Before I added the categories I'd been using this query to get the results from my database

Code:
$query2 = $this->db->getwhere('articles', array('articleSlug' => $this->uri->segment(2)));

Now I need to add to the query something that will identify the articleID and then query the other tables to bring back the categories assigned to the article.

I'm new to this so I'm a little stuck at this point. Any help would be greatly appreciated.


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



Theme © iAndrew 2016 - Forum software by © MyBB