adding problem

[puja]

hey
im trying to add selection from a php form into a mysql database but it i am not sure how to.
ive got drop down lists to make the selection from and ive given them values and i know i need to use the POST method but i just cant seem to get it to work.

my options look like this:

Type:
<select name="select">
<option value='Villa'>Villa</option>
<option value='Caravan'>Caravan</option>
<option value='Lodge'>Lodge</option>
</select>
&nbsp;
Board:
<select name="select">
<option value='Full Board'>Full Board</option>
<option value='Half Board'>Half Board</option>
<option value='B & B'>B & B</option>
<option value='Self-Catering'>Self-Catering</option>
</select> &nbsp;

hope someone can help

[Rich Pedley]

you are using name='select' twice they need to be different, for example:

<select name="accomodation">
<option value='Villa'>Villa</option>
...
</select>

<select name="options">
<option value='Full Board'>Full Board</option>
...
</select>