MySQL database and HTML?

[sayr]

Hello!
I have a problem with data adding form..
Ok, so when I added fields into MySQL database through phpmyadmin, I made there many fields which are 'ENUM' or 'SET' and I wrote few options under those fields.
Now when I have this Html form which can edit old items or add new items into database.
I would like to get scrollbars for those 'ENUM' or 'SET' fields, but how?
I have here a simple html code:

<SELECT NAME="xxx">
<OPTION> 1
<OPTION> 2
<OPTION> 3
<OPTION> 4
<OPTION> 5
</SELECT>

The problem is that I don't know how to get the options from database into <OPTION> 1, <OPTION> 2 and so on...

I hope that somebody understood what I ment here...
Thanks!

[bwh2]

my advice is to not use ENUM or SET. can you show us your current table structure? you might also want to read through this: http://kirupa.com/forum/showthread.php?t=221864

[CrayonViolent]

function getOptions($field,$table) {
$result=mysql_query("SHOW COLUMNS FROM `$table` LIKE '$field'");
if(mysql_num_rows($result)>0){
$row=mysql_fetch_row($result);
$options=explode("','", preg_replace("/(enum|set)\('(.+?)'\)/","\\2", $row[1]));
} else {
$options=array();
}
$optionList='';
foreach($options as $val) {
$optionList.="<option value='$val'>$val</option>";
}
return $optionList;
}

// example
$options = getOptions('fieldnamehere','tablenamehere');
echo "<select name='blah'>";
echo $options;
echo "</select>";