MySQL Fields + Drop Down Box

[Anon]

I have managed to list the fields in a MySQL database through using the example in the PHP manual. But I can't get the results to be listed in a drop down box! Could somebody please show me?

Thanks

[Anon]

These sql query you have to write for all fields and the field name
$stmt = "select from table where username = '$username'";
$result = mysql_query($stmt);
$rowarr = mysql_fetch_row($result);

?>

all the field value of one row will be available in the $rowarr array from [0] to the total number of fields or from diff values from same field run a for loop

now while in HTML coding name the html page to PHP
and
write like this
<select>
<option><? echo($rowarr[0]); ?></option>
and so on for other fields