NEED HELP,

[myedinu]

I am new in php, in I want to write a script that has pages whithin a page so I can change them , for example at the bottom to be able to change pages like this:

<< 1 2 3 4 >>, each of them to be a link,

I want to use this in my photo galery,
Can someone help me with that.

[mikawhat]

Is called pagination...

<?php
$display = 5; //results per page

if (isset($_GET['np'])) { 
    $num_pages = $_GET['np']; 
} else { 
    $query = @mysql_query ("SELECT * FROM scorers ORDER BY goals DESC");
    $num_records = @mysql_num_rows ($query); 

if ($num_records > $display) {
    $num_pages = ceil ($num_records/$display); 
} else {
    $num_pages = 1;
}

}

if (isset($_GET['s'])) { 
    $start = $_GET['s']; 
} else { 
    $start = 0;
}

$query = mysql_query ("SELECT * FROM scorers ORDER BY goals DESC LIMIT $start, $display";
$num = mysql_num_rows ($result); 

echo "<table><tr><td align=\"center\">First name</td><td align=\"center\">Last name</td><td align=\"center\">Goals</td></tr>"; 
while ($row = mysql_fetch_array($query)) {
    $id = $row['id'];
    $first_name = $row['first_name'];
    $last_name = $row['last_name'];
    $goals = $row['goals'];

echo "<tr><td align=\"center\">$first_name</td><td align=\"center\">$last_name</td><td align=\"center\">$goals</td></tr>";
}
echo "</table>";
if ($num > 0) {
    if ($num_pages > 1) {
        echo '<p>';
        $current_page = ($start/$display) + 1;

    if ($current_page != 1) {
            echo '<a href="filename.php?id=' . $id . '&s=' . ($start - $display) . '&np=' . $num_pages . '">Previous</a> ';
        }

        for ($i = 1; $i <= $num_pages; $i++) {
            if ($i != $current_page) {
                echo '<a href="filename.php?id=' . $id . '&s=' . (($display * ($i - 1))) . '&np=' . $num_pages . '">' . $i . '</a> ';
            } else {
                echo $i . ' ';
            }
        }

        if ($current_page != $num_pages) {
            echo '<a href="filename.php?id=' . $id . '&s=' . ($start + $display) . '&np=' . $num_pages . '">Next</a>';
        }


}

echo "</p>";

?>