1
Hello Xooper's .
Today i Played this Code . to See all my Active user's . Although i know i can do it from admin page where select find users .. but i did this way to be able to see all the users with on click just open the file lets say ' Got old and Lazy '
My only Problem is i limited the page with 10 users and cant figuer out how to make Next and back for next 10 users or to go back to the last 10 users .
Any help . Please
//Let's connect to database and choose the database
$result = mysql_query("SELECT * FROM ".$xoopsDB->prefix("users")." WHERE level=1 LIMIT 10");
$rows = mysql_num_rows($result);
if($rows > 0){
//Display users
echo "<table border='1' width='100%'>"
."<tr>"
."<td width='25%'><b>User ID</b></td><td width='25%'><b>level</b></td>"
."</tr>";
while($row = mysql_fetch_array($result)){
echo "<tr><td width='25%'>".$row['uid']."</td><td width='25%'>".$row['level']."</td></td></tr>";
}
echo "</table>";
echo "</td>
</tr>
</table>";