Select Menu

[djmadfish]

I am having trouble coding an HTML Form Select Menu in PHP.

I my other form fields pulling from my MySQL database fine, but I need a drop down menu for a couple items, so my end user doesnt mess up editing certain fields.

I am a newbie, so the simpler the better :-)

Thanks,
Ben

[pedro_gb]

You want to know how to create a HTML form? If so, that is how you do it: (A very basic one.)

<select name="something_id">
<option value="1" selected>This is the default value
<option value="2">Look, another value!
</select>

This needs to be inside a form tag to work (so it knows which page to submit to).

[exbabylon]

this might help a little better:

// connect to database

echo('<select name="menu" size="1">');
$sql = "SELECT * FROM table";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)){
    extract($row);
    echo('<option value="id">$name</option>');
} 

This might help!

God Bless,

Alex Stanton