I was using a post's category ID to display posts from that category on a web page. Ex: Show all posts with a category ID of 10. The two mysql statements looked like: SELECT * FROM wp_post2cat WHERE category_id = '10'. Then: SELECT * FROM wp_posts WHERE ID = '$post_id'. It worked just fine until a recent upgrade. I've upgraded to version 2.7 and now all the database field names have changed and I can't seem to figure out where the category ID's are stored. (The description and ID data appears correct in the 'wp_term_taxonomy' table, but in the 'wp_posts' table, all the values in the 'post_category' field are set to '0'.) What tables and fields do I query to get my original functionality back? Where is the category ID stored for individual posts?
Where is post's category ID stored? (2 posts)
-
rpastirik
Posted 9 months ago # -
The terms taxonomy tables now house categories (both posts and links) and tags.
The article Displaying_Posts_Using_a_Custom_Select_Query#Query based on Custom Field and Category has an example.
Reply
You must log in to post.
