<options> from a database

[djcomplex]

Howdy

i need to make a quite extensive options object for a form im creating is there a way to pull the options from a database if so how would i go about that

many thanks

[jonathen]

This is what I use to generate an <option> form field from a mysql table:

<select name='field_name_here'>
<option disabled name='' value=''></option>";
$link = mysql_connect("$sqlhost","$sqllogin","$sqlpass") or die(mysql_error());
mysql_select_db("$sqldb",$link) or die(mysql_error());
$query="SELECT * FROM your_table ORDER BY 'col_name' ASC" or die(mysql_error());
$result=mysql_query($query) or die(mysql_error());
$num=mysql_numrows($result);
mysql_close();  

$i=0;
while ($i < $num) {
$col_name=mysql_result($result,$i,"col_name");
echo "
<option name='$col_name' value='$col_name'>$col_name</option>
";
++$i;
}

echo "
</select>";

HTH,

Jonathen

[sarahk]

check out this link too

it includes showing the current value.

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10255914

[NoBullMan]

How ould you do it for multiple select boxes? If the selection of an item from the first dropdown is to poulate the second drop down, selecting an option from second dropdown populates the third and so on.

Thanks.

[sarahk]

the simplest way is to have an onchange='submit()' attribute in the <select> tag. That way the form submits with each selection and is rebuilt accordingly.

[djcomplex]

thank you very much it worked perfectly