Title: WP database data dictionary
Last modified: August 18, 2016

---

# WP database data dictionary

 *  [tismey](https://wordpress.org/support/users/tismey/)
 * (@tismey)
 * [21 years, 3 months ago](https://wordpress.org/support/topic/wp-database-data-dictionary/)
 * Hi, sorry if this is really obvious and I’m just missing something. I’m new to
   WordPress, my PHP’s fairly basic, my SQL isn’t a problem (Oracle developer by
   trade).
 * I want my categories to show their whole hierarchy when they are listed. So if
   you have a parent/child hierarchy of:
 * cat
    -childcat –grandchildcat
 * then a post in grandchildcat would be shown as belonging in “cat/childcat/grandchildcat”
   rather than just “grandchildcat”.
 * I know that the information is in the database to do this, and I’m sure I could
   suss out how to do it if I knew where to start! I can’t find any information 
   on the WP data dictionary anywhere, so don’t even know what table I should start
   looking in.
 * Can anyone help a clueless newbie?

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Kafkaesqui](https://wordpress.org/support/users/kafkaesqui/)
 * (@kafkaesqui)
 * [21 years, 3 months ago](https://wordpress.org/support/topic/wp-database-data-dictionary/#post-162257)
 * That functionality is already built into `the_category()` tag; take a look at
   the ‘parents’ parameter:
 * [http://codex.wordpress.org/Template_Tags/the_category](http://codex.wordpress.org/Template_Tags/the_category)
 *  Thread Starter [tismey](https://wordpress.org/support/users/tismey/)
 * (@tismey)
 * [21 years, 3 months ago](https://wordpress.org/support/topic/wp-database-data-dictionary/#post-162439)
 * d’oh! You see? here i am, goggling away and it’s right under my nose!
 * Thanks for that, looks like just what I was after….

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WP database data dictionary’ is closed to new replies.

 * 2 replies
 * 2 participants
 * Last reply from: [tismey](https://wordpress.org/support/users/tismey/)
 * Last activity: [21 years, 3 months ago](https://wordpress.org/support/topic/wp-database-data-dictionary/#post-162439)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics