Here's a way to do it with PHP:
function field_select($table, $field)
{ $result = mysql_query("SELECT $field FROM $table") or
die(mysql_error());
print "<SELECT NAME=\"" . $field . "\">\n";
$limit = mysql_num_rows($result);
for($i = 0; $i < $limit; ++$i)
{ list($value) = mysql_fetch_array($result);
print "<OPTION VALUE=\"" . $value . "\">$value</OPTION>\n";
}
print "</SELECT>\n";
}
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
