php - 选择总是选择最后一个值

Question

我试图按品牌搜索产品，所以我创建了这个选择，但它只选择列表中的最后一个选项。

<select name="brand_id" >
    <option>Brand</option>
    <?php 
        $get_brands = "select * from brands";
        $run_brands = mysqli_query($con, $get_brands);

        while ($row_brands=mysqli_fetch_array($run_brands)) {
            $brand_id = $row_brands['brand_id']; 
            $brand_title = $row_brands['brand_title'];

           echo "<option value='$brand_id'>$brand_title</option>";

        }


    ?>

</select>
<?php
    echo "$brand_title<a href='results2.php?brand_id=$brand_id'>Search</a>";
?>  

标签： phpmysql