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

Question

my query is echoing the right amount of results in my selection box but theyre all blank? super confused any help appreciated

<?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

I presume you're trying to get the team_name from your database not cup_name so it would be:

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