simple drop down menu to mysql

[nadirah81]

Hi....

I have never worked with mysql before. Recently I have created a database named test1, and table named data1. My table consist of 2 field, name and house_type.

This database will be connected to a html form using php script. How do i do it?

This is how my form looked like...

tr>
<td>Name:</td>
<td><input type="text" name="textfield"></td>
</tr>
<tr>
<td>House Type:</td>
<td><select name="comment">
<option>Bungalow</option>
<option>Apartment</option>
<option>Link</option>
</select>
<br>
</p></td>
</tr>

i understand that first I have to be connected to mysql:

<?php
$link = mysql_connect("mysql_host", "mysql_myname", "mysql_mypassword")
or die("Could not connect : " . mysql_error());
echo "Connected successfully";
mysql_select_db("test1") or die("Could not select database");

then, what should I do???

Sorry for taking your time, but I am totally blur.

Thanks.

[monAmour]

<?
$query = "SELECT name,house_type FROM data1 ORDER BY house_type";
$rs = mysql_query($query) or die(mysql_error());
?>
<select name="comment">

<? while($row = mysql_fetch_assoc($rs)) { ?>

<option name="<?=$row['name']?>"><?=$row['house_type']?></option>

<?
}
?>

</select> 

<?
mysql_free_result($rs);
?>