PHP ranking

[Deivas]

Ok,

I have this:

$rowsPerPage = 50;

$pageNum = 1;

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

$offset = ($pageNum - 1) * $rowsPerPage;

$type = $_GET['type'];

$query = " SELECT * FROM servers WHERE type = '$type'" .
        " LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed');


echo "
<table border=\"0\" id=\"hor-minimalist-b\">
<thead>
        <tr>
            <th scope=\"col\">#</th>
            <th scope=\"col\">Name</th>
            <th scope=\"col\">URL/IP</th>
            <th scope=\"col\">Port</th>
            <th scope=\"col\">Short description</th>
            <th scope=\"col\">Type:</th>
            <th scope=\"col\">Added by</th>
            <th scope=\"col\">Votes</th>
        </tr>
    </thead>
    <tbody>
";
$rank = 0;
while($info = mysql_fetch_array( $result )) {
    $rank++;
    Print "<tr>";
    Print "<td><a href=\"?id=" . $info['id'] . "\">" .$info['name'] . "</a></td> ";
    Print "<td>".$info['ip'] . " </td>";
    Print "<td>".$info['port'] . " </td>";
    Print "<td>".$info['shortdesc'] . " </td>";
    Print "<td>".$info['type'] . " </td>";
    Print "<td>".$info['username'] . " </td>";
    Print "<td>".$info['votes'] . " </td>";
}
echo "</tbody>";
Print "</table>";



$query   = "SELECT COUNT(*) AS numrows FROM servers WHERE type='rsps'";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];


$maxPage = ceil($numrows/$rowsPerPage);

$self = $_SERVER['PHP_SELF'];
$nav  = '';

for($page = 1; $page <= $maxPage; $page++) {
    if ($page == $pageNum) {
        $nav .= " $page ";
    }
    else {
        $nav .= " <a href=\"$self?page=$page&type=$type\">$page</a> ";
    }
}

if ($pageNum > 1) {
    $page  = $pageNum - 1;
    $prev  = " <a href=\"$self?page=$page&type=$type\">[Prev]</a> ";

    $first = " <a href=\"$self?page=1&type=$type\">[First Page]</a> ";
}
else {
    $prev  = ' ';
    $first = ' ';
}

if ($pageNum < $maxPage) {
    $page = $pageNum + 1;
    $next = " <a href=\"$self?page=$page&type=$type\">[Next]</a> ";

    $last = " <a href=\"$self?page=$maxPage&type=$type\">[Last Page]</a> ";
}
else {
    $next = ' ';
    $last = ' ';
}

echo $first . $prev . $nav . $next . $last;

 

When I go to the next page, the $ranks starts over again.

How can I make it to continue counting.

[Ruzzas]

I do not understand your problem. Explain what this ranking does and the problem.

[-Karl-]

I think this is what you mean, so take a look at this:

http://www.phpfreaks.com/tutorial/basic-pagination

[Deivas]

I do not understand your problem. Explain what this ranking does and the problem.

 

$rank = 0;
while($info = mysql_fetch_array( $result )) {
    $rank++;
    Print "<tr>";
    Print "<td><a href=\"?id=" . $info['id'] . "\">" .$info['name'] . "</a></td> ";
    Print "<td>".$info['ip'] . " </td>";
    Print "<td>".$info['port'] . " </td>";
    Print "<td>".$info['shortdesc'] . " </td>";
    Print "<td>".$info['type'] . " </td>";
    Print "<td>".$info['username'] . " </td>";
    Print "<td>".$info['votes'] . " </td>";
}
echo "</tbody>";
Print "</table>";

 

When I go to the next page $rank starts from 0 again.

[Ruzzas]

Maybe you should remove $rank = 0;?

[Deivas]

Maybe you should remove $rank = 0;?

 

Fine -.-