Show database results in <select> tags with the option selected shown

[jbachris]

I have a quick <select> tag that I use to create a drop down window of options on the control panel to add a project to the database.

<select name="status">
	<option value="Not Started">Not Started</option>
	<option value="In Progress">In Progress</option>
	<option value="Completed">Completed</option>
	<option value="Waiting on Client">Waiting on Client</option>
</select>

What I would like, is when I go to my edit page the option I had selected when I add automatically be selected. Like if I add say the project name in a text field, I can run a query, then do this:

<td align="left"><input size="50" maxlength="250" type="text" name="project_title" value="<?php echo $row->project_title; ?>"></td>

It'll display the project title I gave it when I added it in the input box already for me.

I'd like the select field to do the same. If I add Project A to the database and select "In Progress" when I go to the edit page, I want "In Progress" to be what's in the <select> tags.

Thanks!

[devinemke]

you need to use the boolean "selected" HTML option attribute. i suggest storing the option in an array, something like:

$array = array(
	'Not Started',
	'In Progress',
	'Completed',
	'Waiting on Client'
);

echo '<select name="status">';
foreach ($array as $value)
{
	echo '<option value="' . $value . '"';
	if ($value == $row['option']) {echo ' selected';}
	echo '>' . $value . '</option>';
}
echo '</select>';