select lists auto selection

[daver1976]

I have code that generates a select list from a table in my db of. The select list is outputting company id and company name.

If Im editing an existing user I want hte selected output from the select list to be that of which is already in the db against their name.

Any ideas how to make one of the outputs selected?

[PallaviDalvi]

do u want to do some thing like this

echo "<select>";
while ($rows=mysql_fetch_array($query))
{
	if ($rows['Co_id'] == $Company_id_i_am_working_on)
		echo "<option selected>". $rows['Company_Name'] . "</option>";
	else
		echo "<option >". $rows['Company_Name'] . "</option>";
}
echo "</select>";