java - 选项标记中的 mysql 列值

Question

$sql1 = "SELECT c.comm FROM enquiry e JOIN comments c ON e.id = c.enquiryId where e.id = '$memberId' AND e.cmpId = '$companyId'";    
$result1 = mysqli_query($conn, $sql1);
echo "<select class='form-control' name='comment'>";
    while($row1 = mysqli_fetch_array($result1, MYSQLI_ASSOC)){
        echo "
  <option value='".$row1['comm']."'>".$row1['comm']."</option>

    </select>";
 }

我想在选项中回显 c.comm 的所有值，但在获取 ptint 时只有一个值请帮忙

Answer 1

把你的关闭</select> while 之后的标签循环。