drop down list value in a query

[barryb1]

Can someone show me how to write a query that contains a value in a drop list.

The list has 3 values to pick from.
Thanks?

[Anon]

yes, I also need a database of used car dealers in a city with a search function model, km, price, dealer name. How can I make this module?

Thank you

[Anon]

primary page to create drop down from database:

$sql = "SELECT * FROM table ORDER BY item DESC";

$connection = mysql_connect($default->db_host, $default->db_user, $default->db_pass)
or die ("Couldn't connect to server.");
$db = mysql_select_db($default->db, $connection)
or die ("Couldn't select database.");
$sql_result = mysql_query($sql)
or die("Couldn't execute query.");
if (!$sql_result) {

echo "nothing found";
} else {<FORM method=\"POST\" action=\"$default->quote_root_url/display.php\">
<select name=\"sel_record\">
";
while ($row = mysql_fetch_array($sql_result)) {
$item= $row["item"];
echo "<option value=\"$item\">$item</option>";
}
echo "
</select>
<INPUT type=\"submit\">
</FORM>";

Next page query based on record selected:

$sql = "select * from table where item ='$sel_record' order by added ASC";

Hope that helps.