php - 为什么我的 PHP 查询显示空白结果

Question

我的查询在我的选择框中回显了适量的结果，但它们都是空白的？ super 困惑任何帮助表示赞赏

<?php
session_start();
$cupsession = $_SESSION['c_cname'];
$teamSet = $mysqli->query("SELECT cup_name FROM teams WHERE cup_name='$cupsession'");
?>



<select name="team-1" required>
        <option value='Holder' disabled selected>Team 1</option> <!--Placeholder for Select-->
          <?php
              while($rows = $teamSet->fetch_assoc()){ //Fills select with cup entries in db
                $teamName = $rows['team_name'];
                echo "  <option value='$teamName'>$teamName</option>";
              }
          ?>
        </select>

Answer 1

我认为您正在尝试从数据库中获取 team_name 而不是 cup_name，所以它会是:

$teamSet = $mysqli->query("SELECT team_name FROM teams WHERE cup_name='$cupsession'");