OK, I found where MT puts the category ID (in the MT_placement tabel under placement_category_id (tested it by doing “SELECT * from mt_placement where placement_entry_id = 1554” and result was placement_category_id = 20, which is the ID for myownbiz.
I can’t seem to get the syntax right on doing a join to show me a recordset with mt_entry.entry _id, mt_entry.entry_status, mt_entry.entry_title, mt_placement.placement_category_id and mt_category.category_description (these fields require fields from mt_entry, mt_placement, and mt_category, with mt_entry to mt_placement on mt_entry.entry_id = mt_placement.placement_entry_id and mt_placement to mt_category on mt_placement.placement_category_id = mt_category.category_id
Try this:
select mt_entry.entry_id, mt_entry.entry_status, mt_entry.entry_title, mt_placement.placement_category_id, mt_category.category_description
from mt_entry, mt_placement, mt_category
where mt_entry.entry_id = mt_placement.placement_entry_id
and mt_placement.placement_category_id = mt_category.category_id
It worked for me.
You might also want to change your blog configuration so that it formats comments based on newlines in the entered comments. I had put in blank lines and such to make my previous comment easier to read, but because you don’t have MT check for newlines to add BR tags everything just runs together. I think it allows for easier to read comments, but this is just a personal preference.