Title: Intermediate Needs SQL HELP
Last modified: August 20, 2016

---

# Intermediate Needs SQL HELP

 *  Resolved [jamkelvl](https://wordpress.org/support/users/jamkelvl/)
 * (@jamkelvl)
 * [14 years, 1 month ago](https://wordpress.org/support/topic/intermediate-needs-sql-help/)
 * I’m new to wordpress and I need some database help and maybe some pseudo code.
   Consider me a layman…
 * **HISTORY**
    I have purchased a theme [http://demos.appthemes.com/?theme=classipress](http://demos.appthemes.com/?theme=classipress)
   and I’m trying to change the theme’s “Category” dropdown. I’ve been in contact
   with the developers, but to no avail.
 * **What I Want To Do**
    I want to modify the themes primary navigation to display
   only the categories each with their own seperate dropdown menu that displays 
   the children of said categories. The native function that comes with this theme
   will not allow this so I need to write my own hack. Only, I do not understand
   the relationships between wp_terms, wp_relationships, wp_taxonomy and wp_posts.
 * **What I Think I Need To Do:**
    1. Understand the database a little more 😐 2.
   Write a custom function that takes a couple parameters to select the parent-category
   based on parameter and display in a drop down only the sub-categories. Sounds
   easy, but this database is what throws me off… 3. The displayed sub-categories
   will of course be links that will then display the associated data.
 * There is a deadline to be met so I do not care if I have to write a custom hack
   that is placed in the presentation layer. Also this is not a big applications
   so I’m not worried about resources.
 * **Can you help?**

Viewing 1 replies (of 1 total)

 *  Thread Starter [jamkelvl](https://wordpress.org/support/users/jamkelvl/)
 * (@jamkelvl)
 * [14 years, 1 month ago](https://wordpress.org/support/topic/intermediate-needs-sql-help/#post-2703448)
 * Consider this solved.

Viewing 1 replies (of 1 total)

The topic ‘Intermediate Needs SQL HELP’ is closed to new replies.

## Tags

 * [function](https://wordpress.org/support/topic-tag/function/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [php](https://wordpress.org/support/topic-tag/php/)
 * [relational database](https://wordpress.org/support/topic-tag/relational-database/)
 * [taxonomy](https://wordpress.org/support/topic-tag/taxonomy/)

 * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
 * 1 reply
 * 1 participant
 * Last reply from: [jamkelvl](https://wordpress.org/support/users/jamkelvl/)
 * Last activity: [14 years, 1 month ago](https://wordpress.org/support/topic/intermediate-needs-sql-help/#post-2703448)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics