help with drop down list selected value

[greedyisg00d]

Hi I have a drop down list which the value is stored in database when I submit the form

]<select name="type" id="Type">
            <option selected="selected" value="">[Select one]</option>
            <option value="Meeting">Meeting</option>
            <option value="Conference">Conference</option>
            <option value="Workshop">Workshop</option>
          </select>

For example the user greedyisgood selects Meeting and store it in the database. My problem is I have an edit page and what I want is the value of dropdown in the database will now be selected in the edit page like this

]<select name="type" id="Type">
            <option value="">[Select one]</option>
            <option selected="selected" value="Meeting">Meeting</option>
            <option value="Conference">Conference</option>
            <option value="Workshop">Workshop</option>
          </select>

Any idea on how it works? Thanks in advance

[kbc1]

When you are in edit mode, you need to select from the database the options and compare the value retrieved with the value of the list box elements. If they match, then show them as selected.

e.g.

// query your database for your list box values
$sqlquery 	= "SELECT * FROM my_list_box_table";
$dataresult = mysql_query($sqlquery);

// loop through the values retrieved storing the data to variables
while ($datarow = mysql_fetch_array($dataresult)) {
	$list_box_id 			= $datarow['list_box_id'];
	$list_box_value_name 	= $datarow['list_box_value_name'];

// if the value of the list box element is the same as the value you retrieved from the database for the user in edit mode ($stored_value_in_db)
if ($list_box_value_name == $stored_value_in_db) {
	$showselected = "selected";
} else {
	$showselected = "";
}

// $showselected will contain 'selected' or be empty here...
echo " <option $showselected value=\"$list_box_value_name\">$list_box_value_name</option>\n";

}
mysql_free_result($dataresult);