Routes and simple craigslist esque categories

[eluser]MT206[/eluser]
Great. This is exactly what I needed. I eliminated the where statement:

Code:

$this->db->where('child.url_name', 'stovetops');

because I want to return all the results for the parent.

Now I just have to hook this into the posts and I will have a fully functioning category-post system. I think just adding a foreign key referring to the category id in the post table and having some validation that makes sure that people don't post in the top level category will suit what I need just fine.

Thank you both for all your help.