[SOLVED] Help with making multiple pages with query results

[PJ droopy pants]

I currently have a page which shows a list of all users in the database. Now that it is over 1000 users I would like to split it into pages of say, 100 users per page. However I have no idea how and any help would be great. Here is what i am using to get the entire list of users.

echo '<tr><td>Total Users</td></tr>';
echo '<tr><td>';
$result = mysql_query("SELECT * FROM `users` ORDER BY `id` ASC");

while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
		echo "<div>".$line['id'].".)".$line['username']."</div>";
}
echo "</td></tr>";

[elgoog]

What you could try, is sorting by letter

 

Having an alphabet at the top of the page and sql below

 

$letter = $_GET['letter'];

 

"SELECT * FROM `users` WHERE `users` LIKE '$letter%'"

 

Or do a search for pagination. There are some good ready made classes where you could have a certain number per page

[xtopolis]

Basic Pagination Tutorial

[PJ droopy pants]

Thank you that worked beautiful!