Use database column in combo-box (previously: help)

mina_gabriel84

guys i need some one to help me
i select a user_name from the database and i want to put it in a combobox
so could any body told me how to do that
thnx

bpat1434

Welcome to PHPBuilder. It would help us if you posted some code so we could see what you've got so far.

mina_gabriel84

okay i have that simple code :

<? include("con.php") // connect to database

$query=mysql_query("SELECT name FROM lagina . users ")
while($row = mysql_fetch_array($query)){
echo $row[name] ;
}
?>// and it works , what am looking for is to put the selected variable in to a combo box using HTML

NogDog

You are practically there. Just add the html <option> and </option> tag around the value being echoed, then stick your <select> and </select> tags around the whole construct.

mina_gabriel84

it works thanx the problem was that i put the <select><option></option></select> in a separet html after the php code
like that
<html>
<select>
<option> <? echo $row[name] ?> </option>
</selct>
</html>
but now i have the following code :

<?
include("connect.php");

$query=mysql_query("SELECT name FROM lagina . users ");
echo "<select>";
while ($row=mysql_fetch_array($query)) {

echo "<option>" . $row[name] . "</option>" ;
}
echo "</selct>";

?>
and it works thnx man