$db->query("select * from tbl_user order by reset desc limit " . $start . "," . $perpage); while ($res = $db->fetchArray()) { ?> <tr align="center" > <td width="1%"><?php echo $i; $i--; ?> </td> <td width="44%"><?php echo $res['wallet']; ?> </td> <td width="18%"> <?php $db2->Queryres("select count(user_id) as ucount from tbl_user where reffer_id='" . $db->res['user_id'] . "' "); echo number_format($db2->res['ucount']); ?> </td> <td width="31%"><?php echo number_format($res['playnum']); ?> </td> <td width="6%"><a href="user.php?a=delete&id=<?php echo $res['user_id']; ?> ">Delete</a></td> </tr> <?php } ?>