php - 选择从数据库显示到另一页的选项

Question

请帮助我如何将此选择选项下拉列表显示到另一个页面。我得到了数据库的正确内容，当我提交按钮时，如果总是第一行或(默认)它显示的那个。请。

$select_size = mysql_query("SELECT * FROM size_tbl WHERE prod_id ='$prod_aydi' ");
?>  
Size: &nbsp; <select class="details_order1" name="size" >
<?php
while($data=mysql_fetch_assoc($select_size))
{
    $prod_diay = $data['prod_id'];
    $sze = $data['size_name'] ;
    ?>
    <option value="<?php echo $prod_diay ?>"><?php echo $sze ?></option>
    <?php
}
?>
</select>

FUNCTION.php

function get_size($pid) {
    $result=mysql_query("select id from product_tbl where id='$pid' ") ;
    $row=mysql_fetch_array($result);    
    $aydi = $row['id'];

    $sel = mysql_query("SELECT size_name FROM size_tbl WHERE prod_id='$aydi' ");
    $row2 = mysql_fetch_array($sel);            
    return $row2['size_name'];
}

Answer 1

您需要将“selected”属性添加到 <option>您希望在页面加载时被选中。

<option selected>...</option>