Not dropin functional but you should get the idea.
$number_lists = $_POST['lists']; // or $_GET['']
$sql = "select blah,blah2 from blah";
$results = $mysql_query($sql,$connection);
while($row = mysql_fetch_assoc($results))
{
$option_block = $option_block."<option value=\"{$row['blah']}\">{$row['blah2']}</option>";
}
// in your form
$i = 1;
while($i <= $number_lists)
{
echo "<select name=\"value$i\">$option_block</select>";
$i++;
}
This will work, but this method is often not the best way of doing things. Rather then get the user to submit a number you could have a hidden <div> with the <select> inside, include a button on the page to add another select box which calls a javascript function to clone_node the div rename the select name to name+increment and then append inside the form. More complex but more user friendly.
