populate a dropdown box via SQL

[dawizman]

Can anyboddy post a script that will take the data from a mySQL table and insert it into a dropdown box. I am sure it is easy, but i am just overlooking something.


Thanks in advance.

[dawizman]

nm, got it finaly :


<?
$connection = mysql_connect("localhost","user","pass");
$fields = mysql_list_fields("dbname", "table", $connection);
$columns = mysql_num_fields($fields);
echo "<form action=page_to_post_to.php method=POST><select name=Field>";
for ($i = 0; $i < $columns; $i++) {
echo "<option value=$i>";
echo mysql_field_name($fields, $i);
}
echo "</select></form>";
?>

[dawizman]

anyone know why this wont work?



<?PHP
$host = "localhost";
$user = "admin";
$pass = "******";
$db = "products";
$connect = mysql_connect($host, $user, $pass);
mysql_select_db("product", $connect);
$name_proc = mysql_query("SELECT name FROM processor");
$price_proc = mysql_query("SELECT price FROM processor");
$result_proc = mysql_query("SELECT * FROM processor", $connect);
echo "<FORM METHOD='POST' ACTION='continue.php'>";
echo "<SELECT NAME='processor' SIZE='1'>";
for ($i = 0; $i < mysql_num_fields($result_proc); $i++) {
echo "<OPTION VALUE=" . $price_proc . ">";
echo $name_proc;
}
echo "</SELECT>";



?>

[dawizman]

Dam, i should stop posting here, i keep on finding my own answers.