马上注册,结交更多好友,享用更多功能,让你轻松玩转南昌530论坛
您需要 登录 才可以下载或查看,没有账号?注册会员
×
打开/include/global.func.php
在最后边加上以下代码:
function get_com($catid){
global $db;
$sql="select * from ".$db->pre."category where catid=".$catid."";//调用当前栏目所有子分类
$result=mysql_query($sql);
$catids='';
while($count=mysql_fetch_array($result))
{
$catids.=$count['arrchildid'];
}
$row=array();
$sql2="select a.username,a.userid,a.company, COUNT(b.itemid) AS com_num from ".$db->pre."member as a,".$db->pre."mall as b where a.username=b.username and b.catid in ($catids) GROUP BY b.username HAVINg com_num > 0 ";
$result2=mysql_query($sql2);
while($count2=mysql_fetch_array($result2)){
$row[]=$count2;
}
return $row;
}
代码内容不解释
再打开你要用的模板,模板地方参考以下代码,自行修改
{php $cominfo=get_com($c[catid]);}
{loop $cominfo $co $val}
<dd><a rel="nofollow" title="{$val[company]}" target="_blank" href="{userurl($val[username])}"><span>{$val[company]}</span></a></dd>
{/loop}
$c[catid]是上一层loop遍历出来的.把数据取出来了,遍历跟据自己情况写loop吧. |