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
le="color: #000000"><?php //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>";
