Some simple help(i'm sure) needed

[MitchEvans]

I'm new to PHP and was wondering what code I would need in order to show details that are held in a MySQL database. I want users to choose from two text boxes and an answer will come up, this answer needs to come from the database. I have done select statements in MySQL so it works on that interface, not sure if this will help. My HTML code is:

</select>
<select name="Surface">
<option value="Carpet">Carpet</option>
<option value="Vinyl Flooring">Vinyl Flooring</option>
</select>
<select name="Soil Level">
<option value="Light">Light</option>
<option value="Medium">Medium</option>
<option value="Medium">Heavy</option>
</select>

So the user can choose from the dropdown boxes. These details are in the database for example when a user selects carpet and medium a message will be given to them and so on eg. "carpet" and "heavy" will give a different message.

Please help!!!

[thorpe]

What part are you stuck on exactly? Do you have ANY php code? Can you connect to your mysql server?

[MitchEvans]

How do I connect to my MySQL server? I have no code as of yet, just wondered how it could be done as I will need this very soon. Cheers.

[thorpe]

You'll need to ead up on [man]mysql_connect/man, [man]mysql_select_db/man, [man]mysql_query/man and [man]mysql_fetch_assoc/man.

[Houdini]

You also need to fix this part

<option value="Light">Light</option>
<option value="Medium">Medium</option>
<option value="Medium">Heavy</option>

I believe for you to get the proper result it should be

<option value="Light">Light</option>
<option value="Medium">Medium</option>
<option value="Heavy">Heavy</option>