SQL查询结果进入下拉列表

Question

I am trying to get the names of the events from a table in a database, i need to insert this data in a dropdown list, so then someone clicks them and then the information for this specific event displays...

Here is my code up to now..

<?php

require "config.php"; // Your Database details 
?>

<?PHP


$SQL = "SELECT title_en_US FROM civicrm_event";
$result = mysql_query($SQL);
// Write out our query.
$query = "SELECT title_en_US FROM civicrm_event";
// Execute it, or return the error message if there's a problem.
$result = mysql_query($SQL);

while ($db_field = mysql_fetch_assoc($result)) {
print $db_field['title_en_US'] . "<BR>";

}

?>

Can you tell me how to put first the event names into a dropdown list?

Thanks!

Answer 1

Please use the following code

$options='';
while($db_field = mysql_fetch_assoc($result))
{
    $options .= "<option>".$db_field['title_en_US']."</option>";
} 

For the html part,

<select name="titles"><? echo $options; ?></select>