create table with post title and two subcategories…

hi all,

this might be a strange question and I may have thought of a strange way to possible solve it, but I’ll give it a try to get some input.

I’m using WP more as a CMS for a project and wish to let authors write posts (course titles + description in this case) and categorize these by country and institution.

I’ve imagined having “country” and “institution” as top cateogies, and sub categories like “spain”, “USA”, “University of Madrid” etc.

to display this I wish to create a HTML table with the coulumns “course title”, Country” and “institution”, and pull out the data from the post here, so a table row could look like:

Course title | Country | Institution
—————————————
Course in math | Spain | University of Madrid
Course in that | USA | MIT

etc.

I’ve created the table, got the course titles (the_title) and can also get the categories (with the_category). problem starts when I wish one column to show the sub category of the country category, and the other to show the sub category of the institution category, like this:

the_title | category which is child of “country” | category which is child of “institution”.

hm, makes sense? 🙂 any pointers to a solution, or a different solution? I’ve tried with custom fields as well but with no luck yet. also, I’m not at all php savvy..

(in the next step I’d use this table with some JS to make it sortable, with this maybe: http://kryogenix.org/code/browser/sorttable/)