 |
| 用户名 | 游戏一 | 游戏二 | 游戏三 |
用户名 | 游戏一 | 游戏二 | 游戏三 |
Create();
$sqljoin = "select uname from bearUser where bearUser.ID>2001 and bearUser.ID<=2701 order by ID";
//echo $sqljoin;
$sql->Query($sqljoin);
$totalnum+=$sql->rows;
for($i=0;$i<$sql->rows;$i++)
{
$sql->Fetch($i);
echo "| ".$sql->data["uname"]." | ".rand(43,236)." | ".rand(155,577)." | ".rand(0,9)." | ";
if($i%2==1)
{
echo " ";
}
}
$temp=$i%2;
?>
Create();
$sqljoin = "select bearUser.uname as uname,qditest.B as B,qditest.C as C,qditest.D as D from bearUser,qditest,bearUact where bearUser.ID=qditest.uID and bearUser.ID=bearUact.uID and qditest.uact=bearUact.uact and bearUact.uact='SA0419' and qditest.uact='SA0419' order by bearUact.uacttime";
//echo $sqljoin;
$sql->Query($sqljoin);
for($i=0;$i<$sql->rows;$i++)
{
$sql->Fetch($i);
echo "| ".$sql->data["uname"]." | ".$sql->data["B"]." | ".$sql->data["C"]." | ".$sql->data["D"]." | ";
if($i%2==(1-$temp))
{
echo " ";
}
}
?>
|
 |
 |
