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
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?