php mysql运算循环出来的字段…
<?php
function _init_navshkshadowss($arr, $db) {
/**
* 板块回复排行总条数
* Enter description here .
* ..
*
* @var unknown_type
*/
$sqlpostssmax = "SELECT * FROM `blg_forum_forum` WHERE `type` = 'forum' AND `status` = '1' AND `fup` != '0' order by posts DESC limit 10";
$query = $db->query ( $sqlpostssmax );
while ( $rs = $db->fetch_array ( $query ) ) {
$numpost = $rs [posts] + $numpost;
}
$sqlpost = "SELECT * FROM `blg_forum_forum` WHERE `type` = 'forum' AND `status` = '1' AND `fup` != '0' order by posts DESC limit 10";
$query = $db->query ( $sqlpost );
$i = 0;
while ( $rs = $db->fetch_array ( $query ) ) {
$i ++;
$rs ["i"] = $i;
$rs ["numpost"] = $numpost;
$u [] = $rs;
}
$this->var ['setting'] ['forumn'] = $u;
}
?>