请假：Warning: Division by zero in 错误

cniceker 2009-12-02 09:25:23

错误提示：Warning: Division by zero in E:\myweb\admin\suteadmin.php on line 120

本人不懂PHP 网上找了资料说是被除0了，具体怎么改谢谢！！！！谢谢了！！

suteadmin.php完整代码如下：

<?
///////////删除操作
if(!empty($delid) && $del_submit=="删" && $_SESSION["admin_droit"]==1){
$sqlu="select * from user where id='$delid'";
$rsu=mysql_query($sqlu);
$rowu=mysql_fetch_array($rsu);
if($rsu){
$snum=$rowu[tot_out]*0.2;
if(!empty($snum)){
$sqlp="update user set spare=spare-$snum where username='$rowu[up_user]'";
$rsp=mysql_query($sqlp);
}else{
$rsp=1;
}
}
if($rsp){
$sql="delete from user where id='$delid'";
$re=mysql_query($sql);
if($re){
echo "　 <span class=links>帐户删除成功！上线用户剩余已经扣除 $snum </span>";
}else{
echo "　帐户删除更新失败！";
}
}
}

////////////////

$outstr="";
if($stat!=9){
$where="and isadmin='$stat'";
}else{
$where="";
}

if(!empty($sch)){
$where=$where." and (`username` like '%$sch%' or `key` like '%$sch%' or `url` like '%$sch%' or `sitename` like '%$sch%')";
}else{
$where=$where;
}

if(!empty($date_1) && !empty($date_2)){
$where=$where." and (retime>'$date_1' and retime<'$date_2')";
}else{
$where=$where;
}

if($sstype!="0" && !empty($sstype)){
$where=$where."and stype='$sstype'";
}else{
$where=$where;
}

if(!empty($upuser)){
$where=$where."and up_user='$upuser'";
}else{
$where=$where;
}

if(empty($orderkey)){
$order="order by day_out desc";
}else{
$order="order by $orderkey $ordermd";
}

$sql="select * from user where id>0 $where $order";
$list_count="user where id>0 $where";
$count_sql="select sum(tot_out) as t_tot_out ,sum(tot_in) as t_tot_in ,sum(spare) as t_spare,sum(money) as t_money from user where id>0 $where";
$count_re=mysql_query($count_sql);
$count_row=mysql_fetch_array($count_re);

$nday=date("Y-m-d")." 00:00:00";
$dao_sql="select sum(day_out) as t_day_out from user where id>0 and last_out>='$nday' $where";
$dao_re=mysql_query($dao_sql);
$dao_row=mysql_fetch_array($dao_re);
$dai_sql="select sum(day_in) as t_day_in from user where id>0 and last_in>='$nday' $where";
$dai_re=mysql_query($dai_sql);
$dai_row=mysql_fetch_array($dai_re);

$pagesize=$cfg_page;
require_once("../public/pagehead.php");

$re=mysql_query($sql);
if($stat!="5"){
$del_op="<input type=submit name=del_submit value=删>";
}else{
$del_op="--";
}

$nday=date("Y-m-d")." 00:00:00";
while($row=mysql_fetch_array($re)){
if($row["last_out"]>=$nday){
$day_out=$row[day_out];
}else{
$day_out=0;
}
if($row["last_in"]>=$nday){
$day_in=$row[day_in];
}else{
$day_in=0;
}
$retime=str_replace("-",".",substr($row["retime"],2,8)."<br>".substr($row["retime"],11,8));

$wqq = "";
$qpastyle=1;
if($row["qq"]!=""){
//$wqq = "<a target=blank href=http://wpa.qq.com/msgrd?V=1&Uin=".$row["qq"]."&Site=www.001122.com&Menu=yes><img border=\"0\" SRC=http://wpa.qq.com/pa?p=1:".$row["qq"].":$wpastyle alt=\"点击这里给".$row["qq"]."发消息\"></a>";
}

if($_SESSION["admin_droit"]==1){
//$userstr="<a href=$PATH?p=useradmin&id=$row[username] class=links target=_blank>$row[username]</a><br><a href=$PATH?p=login&id=$row[username] class=links target=_blank></a><br><a href=$PATH?p=check&id=$row[username] class=links target=_blank>查</a> <a href=$PATH?p=check2&id=$row[username] class=links target=_blank>查2</a> <br/>$wqq";
$userstr="<a href=$PATH?p=useradmin&id=$row[username] class=links target=_blank>$row[username]</a><br><a href=$PATH?p=login&id=$row[username] class=links target=_blank>******</a><br><br/>$wqq";
}else{
//$userstr="<a href=$PATH?p=login&id=$row[username] class=links target=_blank>$row[username]<br>$row[pwd]</a>";
$userstr="<a href=$PATH?p=login&id=$row[username] class=links target=_blank>$row[username]<br>******</a>";
$del_op="--";
}
//$userstr="<a href=$PATH?p=login&id=$row[username] class=links target=_blank>$row[username]<br>******</a>";
$mmcs=round($row["leave"]/$row["day_out"]);

if($_SESSION["admin_droit"]==1)
{
if( $row["username"] != "zcw.com")
{
$outstr.="
<tr class=contbcon>
<td>$userstr</td>
<td align=left>$row[sitename]<br><a href=$row[url] target=_blank>".substr($row[url],0,20)."...</a></td>
<td align=center>$mmcs</td>
<td>$row[stype]</td>
<td>$row[credit]</td>
<td>$row[zb]</td>
<td width=70>$retime</td>
<td>$day_out</td>
<td>$day_in</td>
<td>$row[tot_out]</td>
<td>$row[tot_in]</td>
<td>$row[down_out]</td>
<td><a href=../user/to_login.php?user=$row[username] class=links target=_blank>$row[spare]</a></td>
<td>$row[money]</td>
<td>$row[up_user]</td>
<td><a href='?p=messadd&user=$row[username]' target='_blank'>TO</a></td>
<form name=form1 method=post action=><td>
$del_op
<input name=delid type=hidden id=delid value=$row[id]>
</td></form>
</tr>";
}
}
else
{
if( $row["username"] != "zcw.com" && $row["username"] != "001122")
{
$outstr.="
<tr class=contbcon>
<td>$userstr</td>
<td align=left>$row[sitename]<br><a href=$row[url] target=_blank>".substr($row[url],0,20)."...</a></td>
<td align=center>$mmcs</td>
<td>$row[stype]</td>
<td>$row[credit]</td>
<td>$row[zb]</td>
<td width=70>$retime</td>
<td>$day_out</td>
<td>$day_in</td>
<td>$row[tot_out]</td>
<td>$row[tot_in]</td>
<td>$row[down_out]</td>
<td><a href=../user/to_login.php?user=$row[username] class=links target=_blank>$row[spare]</a></td>
<td>$row[money]</td>
<td>$row[up_user]</td>
<td><a href='?p=messadd&user=$row[username]' target='_blank'>TO</a></td>
<form name=form1 method=post action=><td>
$del_op
<input name=delid type=hidden id=delid value=$row[id]>
</td></form>
</tr>";
}
}
}
?>

<table width="100%" border="0" cellspacing="2" cellpadding="0" class=text>
<tr> <form name="form_sch" method="post" action="">
<td height="40">
<input name="sch" type="text" id="sch" value="<?=$sch;?>" size="10">
<select name="sstype" id="sstype">
<option value=0>所有类别</option>
<?
for($si=1;$si<=count($cfg_stype);$si++){
$type_name=$cfg_stype[$si];

if($sstype==$si){
$se="selected";
}else{
$se="";
}

echo "<option value=$si $se>$type_name</option>";
}
?>
</select>
<input name="date_1" type="text" id="date_1" size="9" maxlength="10" value="<?=$date_1?>" onDblClick="document.form_sch.date_1.value='<?=$cfg_tday?>'" title="双击获得本日日期">
<input name="date_2" type="text" id="date_2" size="9" maxlength="10" value="<?=$date_2?>" onDblClick="document.form_sch.date_2.value='<?=$cfg_nday?>'" title="双击获得本日日期">
<select name="orderkey" id="orderkey">
<option value="id" <? if($orderkey=="id"){echo "selected";}?>>ID</option>
<option value="retime" <? if($orderkey=="retime"){echo "selected";}?>>时间</option>
<option value="credit" <? if($orderkey=="credit"){echo "selected";}?>>信用</option>
<option value="day_out" <? if($orderkey=="day_out" || empty($orderkey)){echo "selected";}?>>日出</option>
<option value="day_in" <? if($orderkey=="day_in"){echo "selected";}?>>日入</option>
<option value="tot_out" <? if($orderkey=="tot_out"){echo "selected";}?>>总出</option>
<option value="tot_in" <? if($orderkey=="tot_in"){echo "selected";}?>>总入</option>
<option value="spare" <? if($orderkey=="spare"){echo "selected";}?>>剩余</option>
<option value="money" <? if($orderkey=="money"){echo "selected";}?>>余额</option>
<option value="zb" <? if($orderkey=="zb"){echo "selected";}?>>非点</option>
</select>
<select name="ordermd" id="ordermd">
<option value="desc" <? if($ordermd=="desc"){echo "selected";}?>>降序</option>
<option value="asc" <? if($ordermd=="asc"){echo "selected";}?>>升序</option>
</select>
<select name="upuser" id="upuser">
<option value="">推荐人</option>
<?
while(list($k,$v)=each($cfg_admin_user)){
if($k!=1){
echo "<option value=$v ";
if($upuser==$v){
echo " selected";
}
echo ">$v</option>";
}
}
?>
</select>
<input type="submit" name="Submit" value="搜索"> </td>
</form></tr></table>
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr class="contbtit">
<td>用户</td>
<td>站名</td>
<td>评价</td>
<td>类别</td>
<td>信用</td>
<td>非点</td>
<td width="70">时间</td>
<td>日出</td>
<td>日入</td>
<td>总出</td>
<td>总入</td>
<td>下线出</td>
<td>剩余</td>
<td>余额</td>
<td>推荐人</td>
<td>留</td>
<td>删</td>
</tr>
<? echo $outstr;?>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class=text>
<tr>
<td>
<?
$pagestr="&p=$p&stat=$stat&sch=$sch&date_1=$date_1&date_2=$date_2&orderkey=$orderkey&ordermd=$ordermd&sstype=$sstype&upuser=$upuser";
require_once("../public/pagefoot.php");
?>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="4" >
<tr class="leftcontbcon">
<td>本日总点出 <? echo $dao_row["t_day_out"];?></td>
<td>总点出 <? echo $count_row["t_tot_out"];?></td>
<td>剩余积分 <? echo $count_row["t_spare"];?></td>
</tr>
<tr class="leftcontbcon">
<td>本日总点入 <? echo $dai_row["t_day_in"];?></td>
<td>总点入 <? echo $count_row["t_tot_in"];?></td>
<td>余额总数 <? echo $count_row["t_money"];?></td>
</tr>
</table>

...全文