php question

[Anon]

I have written a php script that grabs all the data in my mysql db and returns it to an html form. However, now I would like to let the user choose from three options, then have the database searched for rows that match their selection. Any ideas?

[kennethl]

The form:

<FORM ACTION="script.php">
<SELECT NAME="myfield">
<OPTION VALUE="1">1
<OPTION VALUE="2">2
<OPTION VALUE="3">3
</SELECT>
<INPUT TYPE="submit">
</FORM>

Then in script.php you build your SQL:

$query = "SELECT * FROM mytable WHERE myfield='$myfield'"