我现在在作一个动态关联菜单,是防刷新的那种阿

程序代码如下

<?php
include("adodb/adodb.inc.php");
include("include/config.php");
$db = NewADOConnection("mysql");
$db->Pconnect($dbhost,$dbuser,$dbpassword,$dbname) or die ("Error in sql".$sql.$db ->ErrorMsg());
$sqlpro="select * from classid order by id desc";//查询大分类classid的内容
$bigresult=$db->Execute($sqlpro) or die ("Error in sql".$sqlpro.$db->ErrorMsg());
$btotal=$bigresult->RecordCount();
echo "<script LANGUAGE=\"JavaScript\">\n";
echo "function setcity() {\n";
echo "switch (document.userinfo.classname.value) {\n";
echo "case '':\n";
echo "var labels = new Array('请选择');\n";
echo "var values = new Array('');\n";
echo "break;\n";
for ($i=0;$i<($btotal);$i++)
{
echo "case '";
echo $bigresult->fields['classname'];
echo "' :\n";
$classname=$bigresult->fields['classname'];
$sqlsmallid="select * from smallid where classname= '$classname'";
$sresult=$db->Execute($sqlsmallid) or die ("Error in sql:".$sqlsmallid.$db->ErrorMsg());
$stotal=$sresult->RecordCount();
//labels
echo "var labels = new Array(";
$string="";
$string1="";
for($n=0;$n<$stotal;$n++)
{
$string=$string."\"".$sresult['belongtoid']."\",";
$string1=$string1."\"".$sresult['id']."\",";

}
echo substr($string,0,-1);
echo ");\n";

//values
echo "var values = new Array(";
echo substr($string1,0,-1);
echo ");\n";
echo "break;\n";

}
echo "}\n";


// 清空小分类列表选择框的内容

echo "document.userinfo.belongtoid.options.length = 0;\n";


// 从数组中添加内容
echo "for(var i = 0; i echo "document.userinfo.belongtoid.add(document.createElement(\"OPTION\"));\n";
echo "document.userinfo.belongtoid.options.text=labels;\n";
echo "document.userinfo.belongtoid.options.value=values;\n";
echo "}\n";

// 选择第一个选项
echo " document.userinfo.belongtoid.selectedIndex = 0;\n";
echo "}\n";
echo "</script>";



echo "