select SUM 求和条件问题。 select数据库 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <?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> 广告加载问题请帮处理 roundcube修改密码问题 请教一个菜鸟问题 求ckeditor_3.4.2插入代码功能 如何区分字符串iphone与iphone4? 各位仁兄,高手们请进来帮帮忙。。。计数器统计问题,一定高分悬赏 Zend Studio for Eclipse - 6.1.0 又一个ms不可解问题,如何让web服务器 对同一个session只保持一个页面的请求 CentOs + lnmp下 new memcached()和new memcache() 求高手帮忙看下,关于截取url然后转换的问题 PHP怎么测试? 我自己的服务器,网站 可以访问了,怎么设置好FTP
$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>