dongping4461 2014-10-28 22:35
浏览 57

从数据库php填充下拉框

I have some pretty simple code that is not doing what I want it to do. I just want it to take the unique numbers of the year category in my table and enter them into a dropdown box, but with this code I only get one option which says: $row['year']

Any help is appreciated.

<!DOCTYPE html>
<html>
<form name="testform" method='POST' action='mainck.php'>
<?Php
require "config.php";

echo "<br>Select year first <select name=year id ='s1' onchange=AjaxFunction();>
<option value=>Select a Year</option>";

$sql="SELECT DISTINCT year from PlayerRegSeason";

foreach ($dbo->query(&sql) as $row) {
    echo "<option value=$row['year']>$row['year']</option>";
    }
?>
</select>
</form>
</html>
  • 写回答

2条回答 默认 最新

  • dtef9322 2014-10-28 22:39
    关注

    Missing a lot of quotes in your markup. It's better to be consistent about double vs single quotes, but the following should at least work:

    <!DOCTYPE html>
<html>
<form name="testform" method='POST' action='mainck.php'>
<?php
require "config.php";

echo "<br>Select year first <select name='year' id='s1' onchange='AjaxFunction();'>
<option value=''>Select a Year</option>";

$sql="SELECT DISTINCT year from PlayerRegSeason";

foreach ($dbo->query($sql) as $row) {
    echo "<option value='".$row['year']."'>".$row['year']."</option>";
    }
?>
</select>
</form>
</html>
    评论

报告相同问题？

悬赏问题

  • ¥15 phython路径名过长报错 不知道什么问题
  • ¥15 深度学习中模型转换该怎么实现
  • ¥15 HLs设计手写数字识别程序编译通不过
  • ¥15 Stata外部命令安装问题求帮助！
  • ¥15 从键盘随机输入A-H中的一串字符串，用七段数码管方法进行绘制。提交代码及运行截图。
  • ¥15 TYPCE母转母，插入认方向
  • ¥15 如何用python向钉钉机器人发送可以放大的图片？
  • ¥15 matlab（相关搜索：紧聚焦）
  • ¥15 基于51单片机的厨房煤气泄露检测报警系统设计
  • ¥15 Arduino无法同时连接多个hx711模块，如何解决？