Select value in combobox from DB...!!!

[krazyk]

Hello Friends,

 

i have work with combobox by inserting value from DB dynamically...

 

i just stuck with the situation as m populating combobox as statically , successfully inserting value in DB...

 

but the point is m not sure for how to select perticular value stored in DB for combobox for displaying the data...

 

here is my attempt...

 

Name:
<input type="text" name="txtName" value="<?php print $uName; ?>"/>
<br />

User Type:
<select name="selType">
		<option value="Admin">Admin</option>
		<option value="User">User</option>
	</select>

 

i m getting the value of textbox from select query in the loop bt wht abt combobox value?

 

if for 1 record the name will be krazyk n usertype will be admin then how to select the value from DB?

 

plz suggest me the way to accomplish it...

 

awaiting for your better response...

 

Thank you...!!!

[freaker87]

you can use something like this:-

 

echo "<option value='$id''>$name</option>\n";