I’m desperate for help, I’m creating a website which allows people to sell second hand dancewear online, its just for a project i have to do at uni. Basically i have two tables – a sell table and a product category table. In order to sell an item the user completes an interactive form, in which they must select a category for that product to be sold in (a bit like ebay). I am struggling on how to get what is selected from the drop down box (the category which should be stored in the database) to be written back to the database (i.e. the value to be stored in the sell table alongside the items details). I cannot work out how to create my drop down box so it displays the categories stored in the product category table , and I cannot work out, how when one of these is selected and the form is submitted how to get the id of category to be stored alongside the items details in the sell table, please please can anybody help?!

well, your drop down box should have code similar to this:

<select name="animals" id="animals">
<option value="cows">Cows</option>
<option value="ducks">Ducks</option>
</select>

then you would just do a simple query to insert that

PHP Code:

mysql_query("
INSERT INTO tbl_name 
animal VALUES ('$_POST[animals]')
");