pppp
(php编程)
高级会员
老会员
UID 19770
精华
0
积分 552
帖子 566
金钱 552 喜悦币
威望 0
人脉 0
阅读权限 50
注册 2003-4-21
状态 离线
|
[推荐阅读] 你是什么颜色的看看就知道
<?
//************大类下拉菜单的列表
if($area){
SQL=$DB->query("select * from `product_save` order by ID ASC");
$nCount=$DB->num_rows($SQL);
$area_Main="";
for($i=0;$i<$nCount;$i++){
$cRow=$DB->fetch_array($SQL);
$area_Main .=("<option value='".$cRow['ID']."'");
if($cRow['ID']==$area) $area_Main .=" selected";
$area_Main .=">".$cRow['Title']."</option>\n";
}
} else{
$SQL=$DB->query("select * from `product_save` order by ID ASC");
$nCount=$DB->num_rows($SQL);
$area_Main="";
for($i=0;$i<$nCount;$i++){
$cRow=$DB->fetch_array($SQL);
$area_Main .="<option value=$cRow[ID]>$cRow[Title]</option>\n";
}
}
//************小分类下拉菜单的列表
f($school){
$SQLmiddle=$DB->query("select * from `product_city` where `save_ID`='".$area."'order by ID ASC");
$MCount=$DB->num_rows($SQLmiddle);
$area_middle=" ";
for($i=0;$i<$MCount;$i++){
$MFrow=$DB->fetch_array($SQLmiddle);
$area_middle .="<option value='".$MFrow['ID']."'";
if($MFrow[ID]==$school)$area_middle .="<option value='".$MFrow['ID']."' selected";
$area_middle .=">".$MFrow['Title']."</option>\n";
}
}
else
{$SQLM=$DB->query("select * from `product_city` where `save_ID`='".$area."'order by ID ASC");
$ICount=$DB->num_rows($SQLM);
$area_middle="";
for($i=0;$i<$ICount;$i++){
$rowT=$DB->fetch_array($SQLM);
$area_middle .="<option value=$rowT[ID]>$rowT[Title]</option>\n";
}
}
//************最少分类下拉菜单的列表
if($class)
{
$STRleast=$DB->query("select * from `product_county` where city_ID ='".$school."'order by ID ASC");
$TCount=$DB->num_rows($STRleast);
$area_least="";
for($i=0;$i<$TCount;$i++){
$STrow=$DB->fetch_array($STRleast);
$area_least .="<option value='".$STrow['ID']."'";
if($STrow[ID]==$class)$area_least .="<option value='".$STrow['ID']."' selected";
$area_least .=">".$STrow[Title]."</option>\n";
}
}
else
{
$STRleast=$DB->query("select * from `product_county` where city_ID ='".$school."'order by ID ASC");
$TCount=$DB->num_rows($STRleast);
$area_least="";
for($i=0;$i<$TCount;$i++)
{
$STrow=$DB->fetch_array($STRleast);
$area_least .="<option value=$STrow[ID]>$STrow[Title]</option>\n";
}
}
?>
<SELECT name="area" ONCHANGE="location.href='?user_type=<?=$user_type;?>&area='+this.value"><option>省区域:
</option><?=$area_Main;?></SELECT>
<SELECT name="school"ONCHANGE="location.href='?menuOption=Add&school='+this.value+'&area='+area.value">
<option >市区域: </option><?=$area_middle;?></SELECT>
<SELECT name="class" ONCHANGE="location.href='?menuOption=Add&class='+this.value+'&area='+area.value+'&school='+school.value"><option VALUE="">县区域</option><?=$area_least;?></SELECT> <input type="button" class="button" onclick="popup('New','Check_User.php?area=<?=$area;?>&school=<?=$school;?>&class=<?=$class;?>',520,120)" value="检查代理点区域">
不知道这样对你们有用吗?是我很久以前的东东了.
如果把它修改成js是最好了!
|
|
