$aaa = "SELECT t.* FROM game g left join trade t on g.sid=t.sid and g.gid=t.gid WHERE g.sname = '$sname' and g.gname != '' order by g.sid, g.gid";
$result=mysql_query($aaa);
while($row=mysql_fetch_array($result))
{
$chk=$row[chk]; if($chk=="1" || $chk=="2")
{ $jstock=$jstock+$row[stock];
$jnstock=number_format($jstock); $j++; }
if($chk=='3' || $chk=='4')
{ $fstock=$fstock+$row[stock];
$fnstock=number_format($fstock); $i++;
}
}
$result=mysql_query($aaa);
while($row=mysql_fetch_array($result))
{
$chk=$row[chk]; if($chk=="1" || $chk=="2")
{ $jstock=$jstock+$row[stock];
$jnstock=number_format($jstock); $j++; }
if($chk=='3' || $chk=='4')
{ $fstock=$fstock+$row[stock];
$fnstock=number_format($fstock); $i++;
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货