关于 “列表/菜单”实现数据问题 给你一个ajax联动的试试吧http://topic.csdn.net/u/20080319/11/b3b7f6dc-3284-4e03-be55-d31f1c268fdc.html 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 ajax来做把当你获取了city 的ID时.你可以 select * from school where cityid ='001'.就出来了。 注: 我的 PHP 两个 列表/菜单 代码如下, 如何实现:当第一个列表/菜单的值选定为“海口”时,第二个列表/菜单中值只提供“海南中学”或“海口一中”两个选项值. (其中DmDemand只是一个函数)<? echo "城市:"; echo "<select name='city' >\n"; $StrQuery="select distinct city_id,city_name from city order by city_id"; $StrRes = DmDemand($Strconn,$StrQuery); while($StrRow = oci_fetch_array($StrRes,OCI_BOTH)){ echo "<option value='$StrRow[1]'>$StrRow[1]</option>\n"; } echo "</select>\n"; echo " 学校:"; echo "<select name='school'>\n"; $StrQuery="select distinct school_id,school_name,city_id from school where city_id in (select distinct city_id from citydb where city_name='".$_session['city']."')"; $StrRes = DmDemand($Strconn,$StrQuery); while($StrRow = oci_fetch_array($StrRes,OCI_BOTH)) { echo "<option value='$StrRow[1]'>$StrRow[1]</option>\n";} echo "</select>\n"; ?>关键是 city 值如何变化,谢谢! Notice: Array to string conversion 懂cakephp的帮忙看一下这段cakephp的代码,为什么AuthComponent::user('id')取不到值 php中的大括号的用法 PHP分页问题 php正则提取 急!!!哪位高手帮帮我啊? PHP如何生成此文件? sessionid用什么获取更好?md5()么? mysql的分区,hash分区探讨 谁能解释下这个下载 中国最强劲的公交搜索PK str_replace的奇怪现象,大家帮帮忙
<?
echo "城市:";
echo "<select name='city' >\n";
$StrQuery="select distinct city_id,city_name from city order by city_id";
$StrRes = DmDemand($Strconn,$StrQuery);
while($StrRow = oci_fetch_array($StrRes,OCI_BOTH)){
echo "<option value='$StrRow[1]'>$StrRow[1]</option>\n";
}
echo "</select>\n"; echo " 学校:";
echo "<select name='school'>\n";
$StrQuery="select distinct school_id,school_name,city_id from school where city_id in (select distinct city_id from citydb where city_name='".$_session['city']."')";
$StrRes = DmDemand($Strconn,$StrQuery);
while($StrRow = oci_fetch_array($StrRes,OCI_BOTH)) {
echo "<option value='$StrRow[1]'>$StrRow[1]</option>\n";}
echo "</select>\n";
?>关键是 city 值如何变化,谢谢!