真的啊,要不我把从ASP修改过来的代码帖出来看看大家参考下<? require_once("../db_fns.php"); require_once("../func.php"); ?> <HTML> <meta http-equive=content-type content=iocharset=gb2312> <HEAD> <TITLE>11</TITLE> <? $conn=db_connect(); $sqlstr="select place from goldcard order by id desc"; $query=mysql_query($sqlstr,$conn); $sqlstr1 = "select place,trade from goldcart order by id desc"; $query1=mysql_query($sqlstr1,$conn); ?> <script language = "JavaScript"> var onecount; onecount=0; subcat = new Array(); <? $CountLinkAction = 0; while($array_ts=mysql_fetch_array($query1)) { ?> subcat[<?=$CountLinkAction?>] = new Array("<?=$array_ts(trade)?>","<?=$array_ts(place)?>"); <? $CountLinkAction++; } ?> onecount=<?=$CountLinkAction?>; function changelocation(locationid) { document.form1.nsort.length = 0; var locationid=locationid; var i; document.form1.nsort.options[0] = new Option('选择小类',''); for (i=0;i < onecount; i++) { if (subcat[i][1] == locationid) { document.form1.nsort.options[document.form1.nsort.length] = new Option(subcat[i][0], subcat[i][0]); } }
其实就是把数据库的数据提取出来生成JS数组就可以了
1:数据库取出记录生成JS数组,用JS数组做数据,做二级连动。
2:数据库取出记录生成XML文件,在客户端用XML数据岛+JS做。
个人推荐第二种方法。方便,并且分离了客户端和服务器端的代码
require_once("../db_fns.php");
require_once("../func.php");
?>
<HTML>
<meta http-equive=content-type content=iocharset=gb2312>
<HEAD>
<TITLE>11</TITLE>
<?
$conn=db_connect();
$sqlstr="select place from goldcard order by id desc";
$query=mysql_query($sqlstr,$conn);
$sqlstr1 = "select place,trade from goldcart order by id desc";
$query1=mysql_query($sqlstr1,$conn);
?>
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<?
$CountLinkAction = 0;
while($array_ts=mysql_fetch_array($query1)) {
?>
subcat[<?=$CountLinkAction?>] = new Array("<?=$array_ts(trade)?>","<?=$array_ts(place)?>");
<?
$CountLinkAction++;
}
?>
onecount=<?=$CountLinkAction?>; function changelocation(locationid)
{
document.form1.nsort.length = 0;
var locationid=locationid;
var i;
document.form1.nsort.options[0] = new Option('选择小类','');
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.form1.nsort.options[document.form1.nsort.length] = new Option(subcat[i][0], subcat[i][0]);
}
}
}
</script>
</HEAD><BODY>
<form name="form1" method="post" action="">
<select name="sort" onChange="changelocation(document.form1.sort.options[document.form1.sort.selectedIndex].value)">
<option selected>大类</option>
<?
while($array_city=mysql_fetch_array($query)) {
echo "<option value=".$array_city("place").">".$array_city("place")."</option>";
}
?>
</select>
<select name="nsort" id="nsort">
<option selected>小类</option>
</select>
</form>
</BODY>
</HTML>
只能显示出“大类”,而且里面也没有内容,请问MYSQL数据库表结构是怎么样的啊?