Help Again

[Anon]

Hi There!
i'm designing a form using HTML and PHP.
i want to know make it with lists or multiples menus, but i'dont know the code for make it "pull data" from the DB, and put them in the multiple list

Can anyone help me?

i'll appreciate your help

Tks/Rgds

José Lopez
Torreón Coahuila México

************ SPANISH VERSION******

Hola!

estoy diseñando un formulario usando HTML y PHP,lo que deseo es que el usuario eliga uno de varios registros, mediante una lista multiple o menu multiple , que tiene mas o menos la el sig. codigo:
<select name="ac_vehiculo">
<option value="si" selected>SI</option>
<option value="no">NO</option>
<option>
.
.
</option>
</select>
lo que deseo saber es la codificacion PHP necesaria para que dinamicamente "jale" los registros desde una base de datos MySQl, y me los ponga en esa lista multiple para que el usuario solo eliga uno.

Muchisimas Gracias.....
Saludos
Jose Lopez

[Anon]

Is this what you mean?

$db = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("sitesearch",$db);

print ("<table border='0' cellpadding='0' cellspacing='0'>\n");
$result = mysql_query("SELECT DISTINCT $field from $dbtable");
print ("<form name='theform' action='whatever.php3' method='get'>");
print ("<tr><td><font face='arial' size='2' color='#262699'><b>Search Database for:</b></font> ");
printf("<select>");
print ("<option selected>choose a category</option>");
while ($myrow = mysql_fetch_array($result))
{
printf("<option value='$myrow[category]'>$myrow[field]</option>");

}
//End while
print ("</select> <input type='submit' name='go' value='Go'>");
print ("</td></tr>\n</form>");
print ("</table>\n<br>");

scott d~