On the fly drop down menus

[Anon]

Instead of listing out my cities in four rows,

while ($r=mysql_fetch_array ($result) )
{
$City=$r["City"];
$count++;
echo " <td bgcolor='#FFFFFF' width='22%' align='center'><A HREF='showinfo.php?City=$City'>$City</A></td>";
if ($count%4==0) //every third row
{
echo "</tr><tr>";
}

how would you populate a drop down menu in php.

Thanks

[Anon]

You'd do something like this:

<form action="showinfo.php">
<select name="City">
<?
while ($r=mysql_fetch_array ($result) )
{
$City=$r["City"];
print "<option value=\"$City\">$City</option>\n";
}
?>
</select>
</form>

Diego

[Anon]

hello again...

this function returns a selectbox

call it like:

while ($r=mysql_fetch_array ($result) )
{
$CityArr[]=$r["City"];
}
$box=make_options($CityArr,"City",1);
// for example continue like this:
echo "<FORM ACTION=showinfo.php>\n";
echo $box."\n";
echo "<INPUT TYPE=SUBMIT VALUE=SHOW>\n";
echo "</FORM>\n";
exit;

###################################
function make_options($values, $SNAME, $SSIZE = "", $SELECTED = "", $wert = "", $multi = "")
{
if(!is_array($values) || $SNAME == "")
{
return false;
}

$option = "";
for($i = 0; $i < count($values); $i++)
{
  if ($values[$i] == $SELECTED && $SELECTED != "")
  {
	    $option = $option."<OPTION selected";

			if ($wert)
			{
				$option = $option." VALUE=\"$wert[$i]\"";
			}

			$option = $option.">".$values[$i]."</OPTION>\n";
  }
  else
  {
    $option = $option."<OPTION";

			if ($wert)
			{
				$option = $option." VALUE=\"$wert[$i]\"";
			}

			$option = $option.">".$values[$i]."</OPTION>\n";
  }
	}

	if ($multi)
	{
  	$OPT_TOP = "<SELECT NAME=\"".$SNAME."\" SIZE=\"".$SSIZE."\"".$KEY." multiple>\n";
	}
	else
	{
  	$OPT_TOP = "<SELECT NAME=\"".$SNAME."\" SIZE=\"".$SSIZE."\"".$KEY.">\n";
	}

	$OPT_BOT = "</SELECT>\n";
  $option = $OPT_TOP.$option.$OPT_BOT;
  return $option;

}
#####################

have fun
chris

[Anon]

This is the best function for
dynamic html drop-down i've
ever seen!

Great thx chris!!!!

[Anon]

haha