how can i get mysql fields in combo box i write the following codes
but i could not be sucessfull any help

=========================
<?php while($query_data=mysql_fetch_array($result)
{
echo "<option value=$query_data[event_name]</option>";
}?>
</select>
i also used mysql_fetch_row and object methods

pls help me

This is no problem.:)

see this example
    $sqlYearList = "SELECT * FROM vehicle_year";
    db_connect($default_dbname);
    $resultYearList = mysql_query($sqlYearList);
    while ($rowYearList = mysql_fetch_array( $resultYearList )){
        $selectYearList = $selectYearList . "<OPTION VALUE='$rowYearList[0]'>$rowYearList[1]</OPTION><br>";
    }
    echo $selectYearList;

// Thae vehicle_year table have 1st 2 fields year_code and year respectively.

Happy programming.

Musharaf ;)

Musharaf Choudhry

Thanks musharaf thanks alot

Your problem was that you were missing the closing paren in your while() conditional expression.


Take care,

Nik
http://www.bigaction.org/