<?
if(!isset($fid)){
$fid=-1;
}SQL_QUERY("select * from category where fid=$fid");
while(RESAULTSET.next()){
SQL_QUERY("select count(*) as fcount from category where fid=".RESAULTSET("id"));
if(RESAULTSET1("fcount")>0){
echo "<a href=$PHP_SELF?fid=".RESAULTSET("id").">name</a><br>";
}else{
echo "name<br>";
}
}
?>由于不知道你用的是什么数据库,数据库连接相关语句只代表意义,不是真实语句.
if(!isset($fid)){
$fid=-1;
}SQL_QUERY("select * from category where fid=$fid");
while(RESAULTSET.next()){
SQL_QUERY("select count(*) as fcount from category where fid=".RESAULTSET("id"));
if(RESAULTSET1("fcount")>0){
echo "<a href=$PHP_SELF?fid=".RESAULTSET("id").">name</a><br>";
}else{
echo "name<br>";
}
}
?>由于不知道你用的是什么数据库,数据库连接相关语句只代表意义,不是真实语句.
if(!isset($fid)){
$fid=-1;
}SQL_QUERY("select * from category where fid=$fid");
while(RESAULTSET.next()){
SQL_QUERY("select count(*) as fcount from category where fid=".RESAULTSET("id"));
if(RESAULTSET1("fcount")>0){
echo "<a href=$PHP_SELF?fid=".RESAULTSET("id").">".RESAULTSET("name")."</a><br>";
}else{
echo RESAULTSET("name")."<br>";
}
}
?>
1 a a1 -1
2 a a2 -1
3 a a3 -1
4 a a4 -1
... ... ...
改一下数据库如何?