I want the SQL query to echo like 10-15 lines then have it make another page, how would I go about doing this?

like
Users 10 then the next page would echo 11-20 and ext.

PHP Code:

$page = $_GET['page']; //assuming the page is passed by url
$offset = 5;
$upper = $page * $offset;
$lower = $upper - $offset;

$query = "SELECT * FROM `table` LIMIT $lower , $upper";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
     //echo here
} 


I think that code will give you an off-by-one bug but that's the general idea.

what would be a code to move to the next page?
like <a href="userlist.php?page="thenextpage">bla</a>

edit: never mind I did it.

PHP Code:

<? echo $_GET['p'] + 1; ?>

$query = "SELECT * FROM `table` LIMIT $lower , $upper";

Wrong. Syntax for limit in select statements is "limit $from, $count", not "limit $from, $to". So the correct answer is:

$query = "SELECT * FROM `table` LIMIT $lower , $offset";

Is there anyway to get rid of the error when the page variable isn't set?

PHP Code:

if( isset($_GET['page']) )
{
     $page = $_GET['page'];
}
else
{
     $page = 1;
} 


So how would I use this tho lol, I am still new.

edit:
oh if there is more than 1 pages it will start to echo 25, other than 15. and echos the stuff that should be on the next page on page 2, like say
foo is on page 2 but it should be on page 3, it will echo on both pages.

The process you are looking for is called pagination. You can find great tutorials in a Google search for php examples.

Its use now,

PHP Code:

<?
$page = $_GET['p']; //assuming the page is passed by url
$offset = 25;
$upper = $page * $offset;
$lower = $upper - $offset;
$next = $_GET['p'] + 1;
$back = $_GET['p'] - 1;

    $result = mysql_query("SELECT * FROM users ORDER BY username ASC LIMIT $upper, $offset") or die("");  //mysql_error()
    while($row = mysql_fetch_array($result))
    {
        $uStatus;
            if($row['rights'] == 1)
                {
                    if(returnRights(loggedUser()) >= 2)
                    {
                        $uStatus = "Regular";
                        $row['username'] = "<b>".$row['username']."</b>";
                    }
                    else
                    {
                        $uStatus = "Regular";
                    }
                }
            else if($row['rights'] == 2)
                {
                    $uStatus = "<b><font color=\"darkgreen\">Moderator</font></b>";
                    $row['username'] = "<b><font color=\"darkgreen\">".$row['username']."</font></b>";
                    $row['signature'] = "<font color=\"darkgreen\">".$row['signature']."</font>";
            }
            else if($row['rights'] == 3)
                {
                    $uStatus = "<b><font color=\"green\">Administrator</font></b>";
                    $row['username'] = "<b><font color=\"green\">".$row['username']."</font></b>";
                    $row['signature'] = "<font color=\"green\">".$row['signature']."</font>";
}
            else if($row['rights'] >= 4)
                {
                    $uStatus = "<b><font color=\"orange\">Owner</font></b>";
                    $row['username'] = "<b><font color=\"orange\">".$row['username']."</font></b>";
                    $row['signature'] = "<font color=\"orange\">".$row['signature']."</font>";
            }

            if(returnRights(loggedUser()) >= 2)
                {
                    echo '<tr>
                            <td><a href="profile.php?uid='.$row['id'].'" target="_blank">'.$row['username'].'</a></td>
                            <td>'.$uStatus.'</td>
                            <td>'.$row['signature'].'</td>
                        </tr>';
            }
            else
                {
                    echo '<tr>
                            <td>'.$row['username'].'</td>
                            <td>'.$uStatus.'</td>
                            <td>'.$row['signature'].'</td>
                        </tr>';
            }
    } 
?>

PHP Code:

<?
if($_GET['p'] == "") { 
    echo '<a href="userlist.php?p='.$next.'">Next Page</a>'; 
} 
else if($_GET['p'] == 0) {
    echo '<a href="userlist.php?p='.$next.'">Next Page</a>';
}
else if($_GET['p'] >= 1) {
    echo '<a href="userlist.php?p='.$back.'">Back Page</a> - 
    <a href="userlist.php?p='.$next.'">Next Page</a></center>'; 
} 
?>