从数据库填充的PHP下拉列表

Question

I need to pull down a column of color codes for a color picker site I'm making but it won't work:

<select name="select" id="dropdown">
    <option id="0">-- Select Color --</option>
    <?php
        $getColors = mysql_query("SELECT * FROM color_codes");
            while($list = mysql_fetch_array($getColors)){
    ?>
        <option id="<?php echo $list ['colorID']; ?>">
        <?php echo $list['color_code'] ?></option>
        <?php } ?>
</select>

Any ideas?

Answer 1

just did a couple of changes to your code and it worked for me, Hope it works for you.

 <?php

$mysqli= new mysqli(DB_HOST,DB_USER,DB_PASS,DB_NAME) or die(mysqli_connect_error());

$sql="select * from test";
$result=$mysqli->query($sql);
?>
<select name="select" id="dropdown">
    <option id="0">-- Select Color --</option>

<?php
            while($list = $result->fetch_array(MYSQLI_ASSOC)){
    ?>
        <option id="<?php echo $list['id']; ?>">
        <?php echo $list['name'] ?></option>
        <?php } ?>
</select>