Funny you should ask - just done it myself:
<?php
$table="shoots";
require ("connect.php4");
$result=MYSQL_QUERY( "SELECT eventName FROM $table");
$num_rows = mysql_num_rows($result);
for ($i=0;$i<$num_rows;$i++)
{
echo "<option>";
echo mysql_result($result,$i,"eventName");
echo "</option>";
}
MYSQL_CLOSE();
?>
- seb
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]