mySQL PHP dropdown loop

[Anonymous]

hi,

Try this,

<select name="charname" value="Select" size="1"> 
<?php 

    $sql = "SELECT * FROM characters";  
    $result = mysql_query($sql) or die (mysql_error());  
    while ($row = mysql_fetch_array($result)) 
    { 
            $value=$row["your column name"]; 
            $options.="<OPTION VALUE=\"$value\">".$value; 
    } 
    ?> 
            <option>
            <?php echo $options ?>
            </option>
        </select>

Hope this helps

Regards,
Tom Cornar
Trinay Technology Solutions
http://www.trinay.com