$sql = "select k_user.username,k_user.money,k_bet.bet_money,sum(k_bet.fs) as fs,k_bet.status from k_user,k_bet where k_bet.uid=k_user.uid group by k_user.username";
这样呢 $sql = "select k_user.username,k_user.money,sum(k_bet.bet_money),sum(k_bet.fs) as fs,k_bet.status from k_user,k_bet where k_bet.uid=k_user.uid group by k_bet.uid";
<td width="56"><strong><input name="checkall" type="checkbox" id="checkall" onClick="return ckall();"/></strong></td> </tr> <?php $sql = "select k_user.username as username,k_user.money,sum(k_bet.fs) as fs,sum(k_bet.bet_money) as bet_money,k_bet.status,k_bet.bid from k_user,k_bet where k_bet.uid=k_user.uid group by k_bet.uid";
$sql = "select k_user.username,k_user.money,sum(k_bet.bet_money),sum(k_bet.fs) as fs,k_bet.status from k_user,k_bet where k_bet.uid=k_user.uid group by k_bet.uid"; 按照这样的sql,可以完全输出你要的结果。 你可以执行sql,贴出结果看看
表结构如下k_user
----uid--------username-------------money------------------------
1544 qq123456q 99900.00
1545 qq123456 95412.00
表结构如下k_bet
----uid--------bet_money-------------fs------------------------
1544 100 1
1545 1000 10
1545 1000 10
1545 1000 10
我要输出的结果为
---username-------money------------bet_money-------------fs-----------
qq123456q 99900.00 100 1
qq123456 95412.00 3000 30
就是输出k_user 表的username,money,k_bet表bet_money ,fs字段的UID相同数据相加。
$sql = "select k_user.username,k_user.money,sum(k_bet.bet_money),sum(k_bet.fs) as fs,k_bet.status from k_user,k_bet where k_bet.uid=k_user.uid group by k_bet.uid";
----uid--------username-------------money------------------------
1544 qq123456q 99900.00
1545 qq123456 95412.00
表结构如下k_bet
----uid--------bet_money-------------fs------------------------
1544 100 1
1545 1000 10
1545 1000 10
1545 1000 10
我要输出的结果为
---username-------money------------bet_money-------------fs-----------
qq123456q 99900.00 100 1
qq123456 95412.00 3000 30
就是输出k_user 表的username,money,k_bet表bet_money ,fs字段的UID相同数据相加。
---username-------money------------bet_money-------------fs-----------
qq123456q 99900.00 100 1
qq123456 95412.00 3100 31
<?php
include_once("../common/login_check.php");
check_quanxian("hygl");
include_once("../../include/mysqli.php");
include_once("../../include/newPage.php");$sql = "select uid from k_user";
if(isset($_GET["order"])) $order = $_GET["order"];
else $order = "uid";$query = $mysqli->query($sql.$desc);if($_GET['page']){
$thisPage = $_GET['page'];
}
$page = new newPage();
$thisPage = $page->check_Page($thisPage,$sum,20,40);$uid = '';
$i = 1; //记录 uid 数
$start = ($thisPage-1)*20+1;
$end = $thisPage*20;
while($row = $query->fetch_array()){
if($i >= $start && $i <= $end){
$uid .= $row['uid'].',';
}
if($i > $end) break;
$i++;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>核查会员财务信息</title><script type="text/javascript" charset="utf-8" src="/js/jquery.js" ></script>
<script language="javascript">
function go(value){
if(value != "") location.href=value;
else return false;
}function check(){
if($("#tf_id").val().length > 5){
$("#status").val("8,0,1,2,3,4,5,6,7");
return true;
}
</script>
<style type="text/css">
<STYLE>
BODY {
SCROLLBAR-FACE-COLOR: rgb(255,204,0);
SCROLLBAR-3DLIGHT-COLOR: rgb(255,207,116);
SCROLLBAR-DARKSHADOW-COLOR: rgb(255,227,163);
SCROLLBAR-BASE-COLOR: rgb(255,217,93)
}
.STYLE2 {font-size: 12px}
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
td{font:13px/120% "宋体";padding:3px;}
a{
color:#F37605;
text-decoration: none;
}
.t-title{background:url(../images/06.gif);height:24px;}
.t-tilte td{font-weight:800;}
</STYLE>
</HEAD><body>
<script language="JavaScript" src="../../js/calendar.js"></script>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td height="24" nowrap background="../images/06.gif"><font > <span class="STYLE2">注单管理:查看所有注单情况(所有时间以美国东部标准为准)</span></font></td>
</tr>
<tr>
<td height="24" align="center" nowrap bgcolor="#FFFFFF">
<table width="100%">
<form name="form1" method="get" action="<?=$_SERVER["REQUEST_URI"]?>" onSubmit="return check();">
<tr align="center"> <td width="124" align="center">
<select name="is_jiesuan" id="is_jiesuan">
<option value="0" style="color:#FF9900;" <?=$_GET['is_jiesuan']=='0' ? 'selected' : ''?>>未返水注单</option>
<option value="1" style="color:#FF9900;" <?=$_GET['is_jiesuan']=='1' ? 'selected' : ''?>>已返水注单</option>
<option value="0,1" <?=$_GET['is_jiesuan']=='0,1' ? 'selected' : ''?>>全部注单</option>
</select></td>
<td width="729" align="left">
会员:
<input name="username" type="text" id="username" value="<?=$_GET['username']?>" size="15">
日期:
<input name="bet_time" type="text" id="bet_time" value="<?=$_GET['bet_time']?>" onClick="new Calendar(2008,2020).show(this);" size="10" maxlength="10" readonly="readonly" /> 注单号:
<input name="tf_id" type="text" id="tf_id" value="<?=@$_GET['tf_id']?>" size="22">
<input type="submit" name="Submit" value="搜索"></td>
</tr>
</form>
</table>
</td>
</tr>
</table><form id="form2" name="form2" method="post" action="check_fs.php?action=xf" onSubmit="return check();">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="right"><span class="STYLE4">
<input name="username" type="hidden" id="username" value="<?=$_REQUEST['username']?>" />
相关操作:</span>
<select name="s_action" id="s_action">
<option value="1">手工返水</option>
</select>
<input type="submit" name="Submit2" value="执行"/></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td height="24" nowrap bgcolor="#FFFFFF"><table width="100%" border="1" bgcolor="#FFFFFF" bordercolor="#96B697" cellspacing="0" cellpadding="0" style="border-collapse: collapse; color: #225d9c;" >
<tr class="t-title" align="center" >
<td width="56"><strong>编号</strong></td>
<td width="96"><strong>下注</strong></td>
<td width="96"><strong>理论返水</strong></td>
<td width="96"><strong>实际返水</strong></td>
<td width="56"><strong><input name="checkall" type="checkbox" id="checkall" onClick="return ckall();"/></strong></td> </tr>
<?php
$sql = "select k_user.username as username,k_user.money,sum(k_bet.fs) as fs,sum(k_bet.bet_money) as bet_money,k_bet.status,k_bet.bid from k_user,k_bet where k_bet.uid=k_user.uid group by k_bet.uid";
$query = $mysqli->query($sql);
while($rows = $query->fetch_array()){
if(in_array($rows['status'],array(0,3,6,7,8))){ //未结算,平手,无效没有退水
if($rows['status']==0){
$ds[$sjc]['other'] .= ',状态:未结算';
$wjs++;
}else{
$ds[$sjc]['other'] .= ',状态:<span style="color:#0000FF;">无效</span>';
}
}elseif($rows['status']==1 || $rows['status']==2){ //输赢都退1%
$ts = $rows['bet_money']*0.01;
$sjfs += $rows['fs'];
$llfs += $rows['bet_money']*0.01;
if($rows['status']==1){
$ds[$sjc]['other'] .= ',状态:<span style="color:#FF0000;">赢</span>';
}else{
$ds[$sjc]['other'] .= ',状态:<span style="color:#00CC00;">输</span>';
}
}elseif($rows['status']==4 || $rows['status']==5){ //输一半,赢一半都退0.5%
$ts = double_format($rows['bet_money']*0.005);
$sjfs += $rows['fs'];
$llfs += double_format($rows['bet_money']*0.005);
if($rows['status']==4){
$ds[$sjc]['other'] .= ',状态:<span style="color:#FF0000;">赢一半</span>';
}else{
$ds[$sjc]['other'] .= ',状态:<span style="color:#00CC00;">输一半</span>';
}
}$wc = abs(double_format($llfs-$sjfs));
?>
<tr align="center" >
<td><?=$rows["username"]?></td>
<td><?=$rows["money"]?></td>
<td>
<?=$llfs?>
</td>
<td>
<?=$sjfs?>
</td>
<td align="center"><?=$wc>0 ? "<input name='id[]' type='checkbox' id='id[]' value='1,44873,44874' />" : ' '?></td>
</tr>
<?
} ?>
</table>
</td>
</tr>
<tr>
<td >
该页统计:总注金:<?=$bet_money?>,结果:<?=$win?>,盈亏:<span style="color:<?=$bet_money-$win>0 ? '#FF0000' : '#009900'?>;"><?=$bet_money-$win?></span>
</td>
</tr>
<tr><td >
<?=$page->get_htmlPage($_SERVER["REQUEST_URI"]);?>
</td></tr>
</table>
</form>
</body>
</html>
你可以执行sql,贴出结果看看