Getting data to drop down list from mysql table

[iimrii]

Hi !

I have a db and in that dataabse there is a table and fields...

name (field)

mumu
koko
keke

and I am creating a html page so when the user opens the page there is a form in that form there is dropdown list like this as in the code

<select name="names">
                      <option selected>mumu</option>
                    </select>

so the thing that i want is that when the web page opens up the dropdown list gets the information from the table filed in name (field) and lincludes in the drop downlist...

I really appreciate it i am new to php still learning 🙂

[foolguitardude]

Well, I don't think its possible in an html file, but in PHP you could to this:

<?
$table = "your_table";

mysql_connect("localhost", "username", "password");
mysql_select_db("your_db");

$query = "SELECT filename FROM $table";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);

echo "<form action=\"your_php_file\" method=\"POST\">";

echo "<select>";

$selected = 1;

while($num_rows > 0)
{
    $name = mysql_fetch_object($result);
    if($selected == 1)
    {
    	echo "<option selected>$name->filename </option>";
        $selected = 0;
    }
    else
    {
	echo "<option>$name->filename</option>";
    }
    $num_rows--;
}

echo "</select>";
echo "<br><input type=\"submit\" value=\"submit\">";
echo "</form>";
?>

Good luck.

[Duey]

that seems a bit long try this:

<?
mysql_connect("localhost", "username", "password");
mysql_select_db("your_db");
$query = "SELECT info FROM mytable";
$result = mysql_query($query);

while($row = mysql_fetch_object($result)){
echo "<option value=\"$row->info\">$row->info</option>";
}
?>

enjoy