[請益] 下拉式選單從資料庫取值後輸出問題

[gaypower (我不是GAY...)]

我想寫一個從下拉式選單取值的功能

試了老半天始終無法將值輸出，硬頭皮來這請教指點@@"

以下為我的程式碼

<select name ="edmtype" size ="1" >
    <?php
    include_once (dirname(__FILE__) . '/../include/mysqlcntdb.php');
    $sql = "SELECT edmmachinename FROM edmmachine";
    $edmmachineamount = mysql_num_rows(mysql_query($sql));
    $edmmachinename = mysql_fetch_array(mysql_query($sql));
    for ($i = 0; $i < $edmmachineamount; $i++) {
        echo '<option value="' . $edmmachinename[i] . '">' . $edmmachinename[i]
        . '</option>';
    }
    ?>
</select>

Debug過程中確認edmmachinename陣列中有值，但到了for迴圈後就是無法輸出@@"

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 220.133.68.104
→ arrack:$edmmachinename = mysql_f...要放迴圈內
→ arrack: $edmmachinename[i] 改成  $edmmachinename[0]
→ tkdmaf:名稱建議：edm_machine_name,edm_machine_amount
推 appleboy46:mysql_query 拉出來寫吧，你這樣執行兩次 query