select SUM 求和条件问题。

<?php
$i=0;
while ($row = mysql_fetch_array($rsnewslist)){
$ts=$row['t7']+$row['t9']-$row['t11']-$row['t12']-$row['t13']+$row['t15']+$row['t16']-$row['t32']-$row['t40'];
$tt1=$tt1+$row['t1'];
$tt32=$tt32+$row['t32'];
$tt2=$tt2+$row['t2']-$row['t3'];
$tt7=$tt7+$row['t7']-$row['t13'];
$tt11=$tt11+$row['t11']-$row['t15'];
$tt12=$tt12+$row['t12']-$row['t16'];
$tt40=$tt40+$row['t40'];
$tts=$tts+$ts;

?>
                            <tr class="t_list_tr_<?=$i%2?>" onmouseover="this.style.backgroundColor='#E8F1FF'" onmouseout="this.style.backgroundColor=''">
                              <td height="36"  align="center"><?=($i+1+($page-1)*20)?></td>
                              <td height="36"  align="center"><a href="./users_info.php?frame=show&uid=<?=$row['username']?>&starttime=<?=$starttime?>+03%3A00%3A00&endtime=<?=$endtime?>">
                                <?=$row['username']?>
                              </a></td>
                              <td align="center"><?=number_format($row['t32'],2)?></td>
                              <td align="center"><?=number_format($row['t2']-$row['t3'],2)?></td>
                              <td align="center"><?=number_format($row['t7']-$row['t13'],2)?></td>
                              <td align="center"><?=number_format($row['t11']-$row['t15'],2)?></td>
                              <td align="center"><?=number_format($row['t12']-$row['t16'],2)?></td>
                              <td align="center"><?=number_format($row['t40'],2)?></td>
                              <td align="center"><?php if($ts<0){echo "<font color='#FF0000'>".number_format($ts,2)."</font>";}else{echo "<font color='#00FF00'>".number_format($ts,2)."</font>";}?></td>
                            </tr>
                            <?php
$i=$i+1;
}
?>
                            <tr class="t_list_tr_2" >
                              <td height="35" colspan="2"  align="center">小结</td>
                              <td align="center"><?=number_format($tt32,2)?></td>
                              <td align="center"><?=number_format($tt2,2)?></td>
                              <td align="center"><?=number_format($tt7,2)?></td>
                              <td align="center"><?=number_format($tt11,2)?></td>
                              <td align="center"><?=number_format($tt12,2)?></td>
                              <td align="center"><?=number_format($tt40,2)?></td>
                              <td align="center"><?php if($tts<0){echo "<font color='#FF0000'>".number_format($tts,2)."</font>";}else{echo "<font color='#00FF00'>".number_format($tts,2)."</font>";}?></td>
                            </tr>
                            <tr>
                              <td colspan="9" class="t_list_bottom"><div style='text-align:right;'>总计
                                <?=$total?>
                                条数据,  共
  <?=$lastpg?>
                                页 , 当前第
  <?=$page?>
                                页  |
  <?php if($page>1){?>
  <a href="?<?=$urls?>&page=1">首页</a> <a href="?<?=$urls?>&page=<?=$page-1?>">上页</a>
  <?php }?>
  <?php for($i=$p1;$i<=$p2;$i++){
if($i==$page){?>
  <span class='Font_R'>
  <?=$i?>
  </span>
  <?php }else{?>
  <a href="?<?=$urls?>&page=<?=$i?>">
  <?=$i?>
  </a>
  <?php }}?>
  <?php if($page!=$lastpg){?>
  <a href="?<?=$urls?>&page=<?=$page+1?>">下页</a> <a href="?<?=$urls?>&page=<?=$lastpg?>">尾页</a>
  <?php }?>
                                | 转至
  <script language="javascript" type="text/javascript">function keepKeyNum(obj,evt){var  k=window.event?evt.keyCode:evt.which; if( k==13 ){ goPage(obj.value);return false; }} function goPage( iPage ){ if( !isNaN(parseInt(iPage)) ) { if(iPage< 0 ){iPage=0;} window.location.href="?<?=$urls?>&page="+iPage;}}</script>
  <input onkeypress="return keepKeyNum(this,event);" type="text" id="iGotoPage" name="iGotoPage" size="3" />
                                页   
  <button onclick="javascript:goPage( document.getElementById('iGotoPage').value );return false;">GO</button>
                              </div></td>
                            </tr>
                          </table>

调试易

select SUM 求和条件问题。

解决方案 »