On Fri, 15 Mar 2002, Jeff Dale wrote: > I want to have a dropdown list populated with data from my MySql server. > > Any examples or websites that could help is appreciated.
function outputSingleSelect() // $name = name to give the HTML form element. // $query = MySQL query. Should return 2 columns. First column // is the key, second is the label. // $default = key of item to be preselected, if any. // $labelchoice = instructional item (like "- Select a city -") to // place at the top of the list { global $DEBUG; list ($name, $query, $default, $labelchoice) = func_get_args(); if (!$query) return; if ($DEBUG) print "<br>Calling outputSingleSelect with $query"; $st = mysql_query($query); if (mysql_errno()) return; $select = "<select name=\"$name\">"; if ($labelchoice) { $select .= '<option value="**"'; if (!$default) { $select .= ' selected'; } $select .= ">$labelchoice"; } while ($row = mysql_fetch_row($st)) { $select .= '<option value="' . $row[0] . '"'; if ($default == $row[0]) { $select .= ' selected'; } $select .= '>' . $row[1]; } $select .= '</select>'; return (mysql_num_rows($st)) ? $select : ''; } -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php