Form for inserting and editing

carisi_2000

I have a form which is used to insert data into a mysql database, one of the fields is a select field and the items in the select field are pulled from the database. This works fine. Then when a hyperlink of a person already in the database is clicked, the form is populated with all of their data for editing purposes, except for in the select field, it continues to show the default option, not the one previously selected and in the database. Hope that makes sense.

planetsim

this makes perfect sense.. I although i may be of no help at all, im in the same boat as you, im not entirely sure what to do.. But i guess i better brush up on my HTML.. if you get a reply with a good answer and works can ya PM..

Thanks

chrisrockshard

I think I can help. Give me a couple minutes to look at how to do it.

chrisrockshard

I'm not sure if this is the answer you're looking for, but the keyword "selected" should be used in the desired <option> tag. I assume you know the php/mysql stuff already, so here is a <select> field where the third option (Dee) is selected by default.

<select name="select" size="1'>
<option value="1">Howdy</option>
<option value="2">Doo</option>
<option value="3" selected>Dee</option>
</select>

Not sure if that's what you were looking for, but I hope it is!

hmogan

This will work:

<select name="category" id="category" onChange="javascript:document.Form.submit();">
<?
foreach ($categories as $key => $value)
{
   echo '<option'; if (isset ($category_id) && $category_id == $key) { echo ' selected';} echo '>' . $value . "\n";
}
?>
</select>

Some notes:
- Ignore the javascript event.
- $categories is an associative array.
- if $category_id is set, it will add selected to the HTML tag, which sets it as default.

You need to step through each option for the menu and when you hit the one that is the current value, make the HTML tag <option selected>

(thanks to devinemke for his help with this and for some sample code!)