I'm creating a separate (simple) directory that does not use any internal WP permalinks or pretty link structure. I've been studying how to make my own custom SEF URLs for this part of my site, and almost have it (or thought so).
I have a separate table with records like this:
id | section | category | co_name 1 | Consulting | Innovation | Innocentive.com 2 | Tasks | Employment | Microtask.com ....
The directory shows a page of all the sections & categories from the database at this URL: dailycrowdsource.com/companies/ (I did this with a companies.php file & created a 'page' with the slug 'companies')
I want this URL to display all the 'employment' category listings: dailycrowdsource.com/companies/tasks/employment/
I can handle the php & mySQL, but I don't know how to make the links pretty. This works http://dailycrowdsource.com/companies/?category=poll
This helped using an extra parameter in an URL, & I think I got it working, but I couldn't figure out how to convert the < a href=.... into the SEF link.
I prefer to do this in my functions.php file, as I haven't written a plugin yet. I've done this in Joomla with the router.php file.
In my research ( Need help with friendly URL's in Wordpress, Custom Post Type Rewrite Rule for Author & Paging?, Rewrite API ), I'm seeing a lot of the same tags & buzzwords, but no one explains how to change the actual link. Does WP do it automatically? (In Joomla you have to do: JRoute::_('index.php?var1=great&var2=more'); for the conversion to take place.)
I realize the first answers will tell me to use some built in taxonomy of WP, but I need this to be updated easily. And by adding a record to the database with a brand new section or category, my directory needs to be instantly updated (that's why I've chosen this method - no administration).
I would appreciate someone showing me how to add in hooks/filters/etc to make a custom SEF URL. (All URLs will start with dailycrowdsource.com/companies/ ). (I'm hoping Mike Schinkel reads this - as I got a lot of help from his responses to similar posts)
Thank You -David