$sql=$empire->query("select * from {$dbtbpre}ecms_bumen where leixing=3"); //查询新闻表最新10条记录 $rows=array();
while($r=$empire->fetch($sql)) //循环获取查询记录 { $num = $empire->num("select id from {$dbtbpre}ecms_news where bumen=$r[id] $where"); $arr = array( 'num' => $num, 'title' => $r['title'] );
array_push($rows, $arr); }
array_multisort(array_column($rows,'num'),SORT_DESC,$rows);
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="biaoge"> <tr class="toubu"> <td align="center">排名</td> <td align="center">单位名称</td> <td align="center">投稿数量</td> </tr> <? $no=1; $step=1; foreach ($rows as $key => $value) { if($key>0){ if($rows[$key]['num']!=$rows[$key-1]['num']) { $no=$no+$step; $step=1; } else{ $no=$no; } }
// $no++; ?> <tr> <td style="border-left:#cccccc 1px solid" align="center"><?=$no?></td> <td align="center"><?= $value['title'] ?></td> <td align="center"><?= $value['num'] ?></td> </tr> <? } ?> </table>
上传以下图片:
|