donh61500
2019-03-29 17:58 浏览 65
已采纳

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

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>
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答 默认 最新

  • 已采纳
    dpjmljx90897323 dpjmljx90897323 2019-03-29 18:02

    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'");
    
    点赞 评论 复制链接分享

相关推荐