PHP split results over pages

[Tabo]

I have the following php code;

<?php

    mysql_connect("*", "*", "*") or die("Could not connect to MySQL");
    mysql_select_db("*") or die("Could not connect to MySQL");

    $query = mysql_query("SELECT uid, username FROM fusers_users ORDER BY regdate DESC LIMIT 0,30");
    $user = mysql_fetch_array($query);
    $members = "<b><a href=\member.php?action=profile&uid={$user['uid']}\">{$user['username']}</a></b>,";
    echo $members;
?>

Can someone help me make it so that it selects 30, and then at the bottom of the page there is a link saying more >> then it gets the next 31-60 and so on.

Also right now it is ordered by regdate, how can i use a hyperlink so when it is clicked it orders by username, and change from ASC or DESC by changing a dropdown box??

Thanks.

[metrostars]

Here is the answer to the first question.

<?php

    mysql_connect("*", "*", "*") or die("Could not connect to MySQL");
    mysql_select_db("*") or die("Could not connect to MySQL");

    $query = mysql_query("SELECT uid, username FROM fusers_users ORDER BY regdate DESC LIMIT 0,30");
    $user = mysql_fetch_array($query);
    $members = "<b><a href=\member.php?action=profile&uid={$user['uid']}\">{$user['username']}</a></b>,";
    echo $members;
?>

goes to

<?php

    mysql_connect("*", "*", "*") or die("Could not connect to MySQL");
    mysql_select_db("*") or die("Could not connect to MySQL");
	$startnumber = $_GET['page'] * 30;
	
    $query = mysql_query("SELECT uid, username FROM fusers_users ORDER BY regdate DESC LIMIT $startnumber ,30");
    $user = mysql_fetch_array($query);
    $members = "<b><a href=\member.php?action=profile&uid={$user['uid']}\">{$user['username']}</a></b>,";
    echo $members;
?>

and make the next link equal to resultspage?page=$_GET['page'] + 1;

[JayM]

Here's a wonderful tutorial on pagination:

http://www.phpfreaks.com/print.php?c...rial&tut_id=43

[Naseema]

$maxrec = $_GET['maxrec'] * 1;
$startrec = $_GET['startrec'] * 1;


$l1 = $startrec;
$l2 = $l1 + $maxrec;
//# - if both startrec and maxrec is 0 then set l2 as 100
if($l2 == 0)
$l2 = 100;

//# - set limit to display
if($l2)
$limit = " LIMIT $l1,$l2";
else
$limit = " LIMIT 0,100";//# - default


if($l1 >= $totrows)
{
if($maxrec < $totrows)
$l1 = $totrows - $maxrec;
else
$l1 = 0;
}
//# - assign start and end for a loop
$vStart = $l1?$l1:0;
$vEnd = $l2?($l2<$totrows?$l2:$totrows):$totrows;


//$vEnd = $l2?($l2):$totrows;
//# - fill the XML tags
for($vIndex=$vStart;$vIndex<$vEnd;$vIndex++)
{
----------------------

}