« Google Reloaded? | Main | Three hours downpour »

June 09, 2003

entry_category_id in mt_entry

For the first time, I took a look at MT tables and play around. Then I found the field entry_category_id in table mt_entry contains all NULL value. Shouldn’t it be the category id of the entry? It sounds obvious to get an entry’s category in mt_entry table.

Later, by reading Brad’s SQL statement for Mark’s nothing personal RSS feed, I realized the category id is actually stored at mt_placement. And apparently, it’s for the purpose of able to link one entry to multiple categories. But where could I put the multiple categories to one entry? The option isn’t at new entry or power-editing mode of editing entries.…

[update] I am so careless. There is a little mark “Assign Multiple Categories” sit right beside the Primary Category.

June 9, 2003 05:02 PM | MovableType & Blogging
Related entries

Feed2Podcast - Jan 16, 2006

Technorati is the most friendly web service to non-English blogger - Jan 14, 2006

Ping-o-Matic is down temporary - Jan 14, 2006

New kind of spam - Dec 28, 2005