SQL Help Needed

[maven]

Hi,

 

I'm trying to place three dropdown menus in header.php. One to select manufacturers, one to look through DVDs and one more to look through CDs. They work independantly. So far I have the first one working but I'm having trouble with seperating the two categories (DVD and CDs) apart in different dropdown menus. From what I can tell and have been trying to do is make a renamed copy of categories.php and change the SQL query but my skills are lacking in this area. I found a site using a similar navigation found here

 

I've been through lots of Contributions but haven't found one that works. Can anyone help create a SQL statement for me that selects certain 'categories_id'?

 

thanks!

[kgt]

tep_draw_pull_down_menu('categories_id', tep_get_categories(array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES))));

 

Replace 'categories_id' with the id for CDs and DVDs, respectively.