List box
Posted: Sun Apr 11, 2004 9:03 pm
How to put/display a list of data from table into a list box? Anybody has any idea pls?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<select name="bla" size="1">
<?php
$query = mysql_query("select field1, field2 from table");
while($data =mysql_fetch_array($query))
{
echo '<option value="'.$data['field1'].'">'.$data['field2'].'</option>';
}
?>
</select>