Selecting And Displaying Data From Database To Selectbox

[iNko]

Hi, i want to select data from a database and that it should be displayed in a select list

 

i have this code:

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>Name :</td>
<td>
<?php
$query = mysql_query("SELECT * FROM `table_name`");
while($row = mysql_fetch_assoc($query)){
echo $row['table_row_name'];
}
?>
</td>
</tr>

 

Now it only gets me the data from a row in a table, and writes it in one line.

How do i make it so all the data would go into select list and i could only pick one item?

[ManiacDan]

Print a select list:

 

<td>
<select name="row_name">
<?php
$query = mysql_query("SELECT * FROM `table_name`");
while($row = mysql_fetch_assoc($query)){
echo '<option>' . $row['table_row_name'] . '</option>';
}
?>
</select>
</td>

[iNko]

Hehe thx i also just found another way:

 

   <?php


   function dropDown(){

$options="<select>"; 
$query = mysql_query("SELECT * FROM `Valdymo_grupe`");
while ($row=mysql_fetch_array($query)) { 

$name=$row["valdymo_pav"];
$options.="<option value=\"$name\">".$name."</option>";  
}

$options.= "</SELECT>";
return "$options";
}
   $list = dropDown();
echo "$list";
   ?>

[ManiacDan]

To be clear, this isn't "another way," this is exactly what I suggested.