Archive for wordpress database

How to List all Category IDs from a WordPress MySQL Databese

In my day to day work, one of my jobs is to setup word-press  themes for my clients. Yesterday, I was setting up and configuring a theme that shows latest post from each category in the middle column. The site was over an year old and there were a lot of categories accumulated over time.

Theme had an option where I can put all the categories that I don’t want to display. The theme developer saved time by no providing an interface to select / remove categories. the lazy developer just put a text box where I had to list unwanted categories in comma separated fashion.

Now the challenge for me here was to ask the client which categories they wish to exclude. But in order to do that, I had to provide them a list of all categories. I could simply go to category section of wordpress admin dashboard but catagory ids are not listed there.  so I had to fire up phpMyAdmin and look for a solution in MySQL database of wordpress. Read More