Hi all.
I'm an absolute newbie to this dynamic web development stuff.

I use dreamweaver to develop sites and i would like to know how to store category id's in a drop down menu so that when i enter a product into my form, i can select a category from the drop down menu which adds the correct 'category id' number to the database.

I have 6 categories in the database numbered in the following order:

cat_id 1 > PA and Sound Reinforcement
cat_id 2 > Microphones
cat_id 3 > Signal Processors
cat_id 4 > Guitars and Basses
cat_id 5 > Guitars and Bass Amplifiers
cat_id 6 > Guitars and Bass Effects

I'm using PHP and a mysql database. I'm no coder though.

Thanks

Antony :0)

Macromedia Another $$$$ to spend....

I can't see How you are going to store a data non-visible into a drop down menu.

Either your drop down list is really small and you can just run PHP to assign to correct category against the selection made;
<?php
if ( $selection == "Speakers 80 Watts" ) { $cat=1; }
?>

or your selection is hudge and I can't see why you are using only 1 drop down menu ??

Surely in your example a bit of javascript with 2 drop down menu will work best:
Drop_down menu 1: Select the Category (here you go)
Drop_down menu 2: Select your Item

So when you change the Category on drop_down menu 1, it auto changed the selection available in drop down menu 2.
example:
http://www.felgall.com/jstip22.htm