Page 1 of 1

List box

Posted: Sun Apr 11, 2004 9:03 pm
by S_henry
How to put/display a list of data from table into a list box? Anybody has any idea pls?

Posted: Sun Apr 11, 2004 9:35 pm
by qads

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>

Posted: Mon Apr 19, 2004 3:01 am
by S_henry
Thanx qads. :D