PHP - Help With Pagination Display

Hello friends. I have a pagination script and there are 3 issues I cant seem to figure out. Here is the code:

Code: [Select]
<?php 
// page_name.php 

$page = $_GET['page']; 

//some code 

$your_db = @ new mysqli("hostname", "username", "password"); 
if (mysqli_connect_errno()) 
{ 
    echo 'ERROR!<br />'.mysqli_connect_errno() 
            .' - Not connected : '.mysqli_connect_error().'<br />'; 
    die; 
} 
else 
{ 
    $db_connect = $your_db->select_db("database"); 
    if (!$db_connect) 
    { 
        echo 'ERROR CONNECT DATA BASE'; 
        die; 
    } 
} 

$query = "select fldIconMedium, fldTitle, fldLink from games"; 
//$result = $db_connect->query($query); 
$result = $your_db->query($query); 
$number_of_records = $result->num_rows;
$num_pages = $number_of_records / 16;
if (($number_of_records % 16) > 0 ) 
{ 
    $num_pages++; 
} 

if (strlen($page) == 0) 
{ 
    $page = 0; 
} 
else 
{ 
    $page = $page * 16; 
} 

$br = 1; 
$result->data_seek($page); 
for ($i = $page; $i < $number_of_records; $i++) 
{ 
    //$row = $result->fetch_array(); 
    $row = $result->fetch_assoc(); 
    if ($br <= 16) 
    { 
        echo '<b>'.stripslashes($row['fldIconMedium']).'&nbsp;</b>'; 
        echo stripslashes($row['fldTitle']).'&nbsp;'; 
        echo '<b>'.stripslashes($row['fldLink']).'</b><br />'; 
        $br++; 
    } 
    else 
    { 
        break; 
    } 
} 

for ($j = 0; $j < $num_pages; $j++) 
{ 
    $page_link = $j + 1; 
    echo '<a href="games2.php?page='.$j.'">'.$page_link.'</a>';
} 
echo '&nbsp;'.$number_of_records; 

?>

Here is a database I am using:

|fldID|         |fldTitle|             | fldCategory |  fldIconMedium |         | fldLink |
2415      Krusty Fun House           Skills           krusty.jpg        games.php?id=2415
2415      Krusty Fun House           Skills           krusty.jpg        games.php?id=2415
2415      Krusty Fun House           Skills           krusty.jpg        games.php?id=2415
2415      Krusty Fun House        Adventure       krusty.jpg        games.php?id=2415
2415      Krusty Fun House        Adventure       krusty.jpg        games.php?id=2415
2415      Krusty Fun House        Adventure       krusty.jpg        games.php?id=2415
2415      Krusty Fun House          Action           krusty.jpg        games.php?id=2415
2415      Krusty Fun House          Action           krusty.jpg        games.php?id=2415
2415      Krusty Fun House          Action           krusty.jpg        games.php?id=2415

I have a couple of issues as I am still a noob learning PHP.
=====================================

1. I have no idea how to add a 'Previous' and 'Next' button to the pagination number bar.

2. My results are displayed vertical and I can't make my results display in a horizontal view. 5 results going from left to right and results from top to bottom Basically 5 x 7 table

3. I have an issue with categorizing my games in my pagination table. I have multiple categories like Action, Skills, Arcade, Skills, Mind, Shooter in my database. For example, the pagination script above creates the link to be like this '.php?page=1', when in fact I want the script to search for categories games, example '.php?page=skills', '.php?page=action', '.php?page=adventure' etc..., linking them to the 'fldCategory' column which has the list of the category names of games, and then fetching all the rows of that particular game category and be displayed in the 5 x 7 table. For each result, it would have the Image Icon (fldIconMedium), the Title (fldTitle) under it, and both of them hyper linked to their links from the 'fldLinks' column.


I would really appreciate the help. It has been 2 weeks and I'm very frustrated that I can't figure the 3 points out. 

I am trying to code a php, mysql and jquery pagination much like the way twitter's pagination works.

Page 1 i have

Code: [Select]
<div id="load_more">
<?php
$query = mysql_query("SELECT * FROM comments ORDER BY id DESC LIMIT 5");
        while($row = mysql_fetch_assoc($query)){
        $id = $row['id'];
        // show comments code
        }
?>
</div>
<script type="text/javascript">
$(function()
{
$('.showmore').live("click",function()
{
var ID = $(this).attr("id");
if(ID)
{
$("#more"+ID).html('<img src="ajax-loader.gif" />');
$.ajax({
type: "POST",
url: "comments_more.php",
data: "lastmsg="+ ID,
cache: false,
success: function(html){
$("#load_more").append(html);
$("#more"+ID).remove(); // removing old more button
}
});
}
else
{
$(".morebox").html('No more comments.');// no results
}
return false;
});
});
</script>
<div id="more<?php echo $id; ?>" class="morebox">
<a href="javascript:;" style="text-decoration: none; font-size: 12px; color: #ffffff; font-weight: bold; " class="showmore" id="<?php echo $id; ?>">Load More Comments</a>
</div>

So i am only showing 5 rows untill the link is clicked and then i want it to load more comments from comments_more.php which is  the same page as above just it checks for the lastmsg id and alters the query to WHERE id < '$lastmsg'. Everything works ok for clicking the link and showing more results but it only works once. even if there is more than 10 rows it will show as "no more comments" after 10. Any help will be appreciated thanks.

Hello

Please can someone help me, I currently have all working on my friends online shop other than the pagination.

When clicking a topic say category - products matching that category show, which is fine only if there is more than say 12 records i need to split it between php pages. Again works fine on the first page but when I click previous or last it ignores the id (category) and lists all the products not only under 'Black'

I am really new to PHP so if you can help please could you show me on my code below so I can make sense of it.

here's my could for the category :-

<a href='shop_online2.php?id=<?php echo($row['id']) ?>'>
  <?php echo($row['description']) ?></a>
  <?php } while ($row_cat = mysql_fetch_assoc($cat)); ?>

here's my code for the next button :-

<?
if (!($start>=$record_count-$per_page))
echo " <a href='shop_online2.php?start= $next '>Next</a> ";
?>

Hopefully I will only have to add a variable in the last statement, if so could you please show me the correct formatting for this.

Hope this makes sense ?? 

Thanks

Marc

I am trying to do my own pagination script to better learn php i do need some help.. First let me explain my goal, then show you the code I have which is not working.
I have 5 blogs per page;
I have at least 30 blogs in the database for testing purpose;
I want the pagination to go as shown
if you are first viewing the blog no page selected it will show [1] 2 3 4 5 ... Last Page
if you for example choose page three it will show 1 2 [3] 4 5 ... Last Page
Now what is happening when you click on page 5 or 6 it does First Page... 4 5 [6]
When I would like it to show First Page... 2 3 4 5 [6] or 2 3 4 [5] 6
here is my code
Code: [Select]
<?php
//if current page != 1 show first page link
$Show .= ($this->CurPage != 1 ? "<a href=\"?module=blog&page=1\">First Page</a>... " : "");

//We need the number of start for the for statement
//We need to check if the number of pages excedes three if it does then make the start minus 2 of the current page
$Start = (($this->CurPage - 2) >= 1 ? $this->CurPage - 2 : 1);

//We need the end page for the for statement
$End = (($this->CurPage + 2) <= $this->NumOfPages ? $this->CurPage + 2 : $this->NumOfPages);

//Run End Again to make sure
$NewEnd = ($End <= 3 && $this->NumOfPages > 5 ? $End + 2 : $End);

//Run Start again to make sure
$NewStart = ($this->CurPage >= ($this->NumOfPages - 2) ? $Start - 2 : $Start);

for ($i = $NewStart; $i <= $NewEnd; $i++) {

$Show .= ($i == $this->CurPage ? "<a href=\"?module=blog&page={$i}\"><strong>[{$i}]</strong></a> " :"<a href=\"?module=blog&page={$i}\">{$i}</a> " );

}

//If More than one page and you are not on the last page
$Show .= ($this->CurPage != $this->NumOfPages && $this->NumOfPages > 1  ? " ...<a href=\"?module=blog&page={$this->NumOfPages}\">Last Page</a>" : "");

return $Show;
?>

<?php
require_once('upper.php');

// Connects to your Database
require_once('database.php');
//This checks to see if there is a page number. If not, it will set it to page 1
if (!(isset($pagenum)))
{
$pagenum = 1;
}

//Here we count the number of results
//Edit $data to be your query

$query = "SELECT * FROM events";
$result = mysqli_query($dbc,$query) or die('Not');
$rows = mysqli_num_rows($result);

//This is the number of results displayed per page
$page_rows = 2;

//This tells us the page number of our last page
$last = ceil($rows/$page_rows);

//this makes sure the page number isn't below one, or more than our maximum pages
if ($pagenum < 1)
{
$pagenum = 1;
}
elseif ($pagenum > $last)
{
$pagenum = $last;
}

//This sets range that we will display in our query
$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;

//This is your query again, the same one... the only difference is we add $max into it
$result = mysqli_query($dbc,"SELECT * FROM events $max") or die('Not');

//This is where you display your query results
while($row = mysqli_fetch_array( $result))
{
$Title=$row['Title'];
$City=$row['City'];
$Content=$row['Content'];
//$Photo=$row['Photo'];
$Date=$row['Date'];
$EventId=$row['EventId'];
$Photo=$row['Photo'];
//echo $Photo;

echo "<div><table border='0' cellspacing='0' cellpadding='0' width='389'>
<tr>
<td><img src='images/events_2.png' width='389' height='10'></td>
</tr>

<tr>
<td background='images/events_2_bg.png'>
<table border='0' cellspacing='0' width='359'>
<tr>

<td>
<tr>
<table width='100%' border='0' cellspacing='0' >
<tr>
<td rowspan='3'><img src='$Photo' width='80' height='60'></td>
<td align='left' valign='top' width='180'>$City</td>
<td align='left' valign='top'>$Date</td>
</tr>
<tr>
    <td colspan='3' align='left' valign='top'>$Title</td>

</tr>
<tr>
<td colspan='2'><a href='KnowMore.php?EventId=".$row['EventId']."'>Know more </a> / <a href='EventParticipator.php?EventId=".$row['EventId']."'>click here to participate</a></td>
</tr>

</table>
</tr>

</tr>
</table>
</td>
</tr>

<tr>
<td><img src='images/events_2_bottom.png' width='389' height='10' ></td>
</tr>

</table></div>";

}


echo "<p>";

// This shows the user what page they are on, and the total number of pages
echo " --Page $pagenum of $last-- <p>";

// First we check if we are on page one. If we are then we don't need a link to the previous page or the first page so we do nothing. If we aren't then we generate links to the first page, and to the previous page.
if ($pagenum == 1)
{
}
else
{
echo " <a href='{$_SERVER['pagination.php']}?pagenum=1'> <<-First</a> ";
echo " ";
$previous = $pagenum-1;
echo " <a href='{$_SERVER['page_test.php']}?pagenum=$previous'> <-Previous</a> ";
}
echo $PHP_SELF;


//just a spacer
echo " ---- ";

//This does the same as above, only checking if we are on the last page, and then generating the Next and Last links
if ($pagenum == $last)
{
}
else {
$next = $pagenum+1;
echo " <a href='{$_SERVER['page_test.php']}?pagenum=$next'>Next -></a> ";
echo " ";
echo " <a href='{$_SERVER['page_test.php']}?pagenum=$last'>Last ->></a> ";
}
require_once('lower.php');
?>


Quote

Hi friends............
I want to paginate my page but it not works properly.
It displays first 2 rows but on clicking "Next" nothing happens.
It displays error also "Notice: Undefined variable: PHP_SELF in C:\wamp\www\NGOProject\Elite Brigade\pagination.php on line 112" and "Notice: Undefined index: page_test.php in C:\wamp\www\NGOProject\Elite Brigade\pagination.php on line 124".........
I don't know what to do??????
please help me anyone???????

Hi guy seems to be having bit of trouble with this it gets first id then go's to pot when i hit the number 2 and so on nothing is there any help would be great
Code: [Select]
<?php
$per_page = 1;
$query = mysql_query("SELECT COUNT('id') FROM product");
$pages = ceil(mysql_result($query, 0) / $per_page);
$page = (isset($_GET['id']) AND (int)$_GET['id'] > 0) ? (int)$_GET['id'] : 1;
$start = ($page - 1) * $per_page;
?>
<?php 
if(isset($_GET['id'])){
               $id = $_GET['id'];
                   $query = mysql_query("SELECT * FROM product WHERE  productMenu=" . mysql_real_escape_string((int)$id) . " LIMIT {$start}, {$per_page}")or die(mysql_error());
   
   
   while($row = mysql_fetch_assoc($query)){ ?>
                   <div id="productHolder">
                   <div id="topprodlist">
                   <div id="prodName"><p>Product Name: &nbsp; <?php echo $row['productName']; ?></p></div>
                   <div id="prodCode"><p>Code: &nbsp; <?php echo $row['code']; ?></p></div>
                   <div id="prodSize"><p>Size: &nbsp; <?php echo $row['size']; ?></p></div>
                   <div id="prodDiameter"><p>Diameter: &nbsp; <?php echo $row['diameter']; ?></p></div>
                   </div>
                   <div id="imageBox"><img src="prodimg/<?php echo $row['image']; ?>" width="100" height="100" alt="<?php echo $row['image']; ?>"></div>
                   <div id="prodDescription">
                   <div id="descript"><h5>Description:</h5></div>
                   <div id="prodTextBox"><p><?php echo $row['short']; ?></p>
                    <a href="info.php?in=<?php echo $row['id']; ?> ">More Details:</a>
                   </div>
                   </div>
                   <div id="clear"></div>
                   </div>
                   
  <?php
   }}
   ?>
   <?php 
                   if($pages >= 1){
               for ($x=1; $x<=$pages; $x++){
           echo "<a href=?id=$x> $x   </a>";
           }
               }

?>

Hi Guys,
I tried to put pagination code into my search results but every time I get an ugly error. Can you guys help me please?I just want to put 5 results per page. Why does it have to be so complicated. I am just asking something very simple (Well, it shows that you don't know anything about php dude! ( I am just talking to myself))

<a href="search.php">Search</a><br>
<br>
<?php     

    include("connect.php");  

    $first_name = "%" . $_POST["first_name"] . "%";
    $last_name = "%" . $_POST["last_name"] . "%";
    $age = "%" . $_POST["age"] . "%"; 

    $query=  "SELECT * FROM `contacts` WHERE `first_name` LIKE '$first_name' AND `last_name` LIKE '$last_name' AND `age` LIKE '$age' ORDER BY `contacts`.`first_name` ASC LIMIT 0, 30 ";    
    
    $result = mysql_query($query);
    $num = mysql_num_rows ($result);
    mysql_close();

    if ($num > 0 ) {
        $i=0;
        while ($i < $num) {
            $first_name = mysql_result($result,$i,"first_name");
            $last_name = mysql_result($result,$i,"last_name");
            $age = mysql_result($result,$i,"age");
            $id = mysql_result($result,$i,"id");   

            echo "<b>first name:</b> $first_name<br>";
            echo "<b>last name:</b> $last_name<br>";
            echo "<b>age:</b> $age<br>";
            echo "<a href=\"update.php?id=$id\">Update</a> - <a href=\"delete.php?id=$id\">Delete</a>";
            echo "<br><br>";  

            ++$i; } } else { echo "No Results"; }?>

The problem here is my pagination. It works for the most part. The only part that does NOT work is that when I go to a page OTHER THAN the first page it WILL NOT allow me to click on the edit link and go to the edit matchtype form. It allows me to on the first page of list but not for any after that.

Code: [Select]
<?php

error_reporting(E_ALL);

// Include the database page
include ('../inc/dbconfig.php');

$query = "SELECT 
    CONCAT_WS(' ', handlers.firstName, handlers.lastName) AS name, 
    DATE_FORMAT(matchTypes.dateCreated, '%M %d, %Y') AS dateCreated, 
    matchTypes.ID, 
    matchTypes.matchType 
FROM 
    matchTypes
    INNER JOIN handlers 
        ON matchTypes.creatorID = handlers.ID
WHERE 
    matchTypes.enabled = '0'
ORDER BY 
    matchTypes.matchType";
$result = mysqli_query ( $dbc, $query ); // Run The Query
$rows = mysqli_num_rows($result);

$itemsPerPage = 10;
$pages = ceil( $rows / $itemsPerPage );

?>

<script>
$(document).ready(function() {
    $('a', $('div#addform')).click(function() {
        $('#innerContent').load('forms/' + $(this).attr('id') + '.php?case=addnew');
    });

// Add the table sorter and table paginator plugins
$('#matchTypesPageList').tablesorter()
                            .tablesorterPager({
                    container: $( '#matchTypesPageList .paginate' ),
                    cssPageLinks: 'a.pageLink'
                    });
    $('.edit').click(function(){
        var matchTypeID = $(this).attr('rel');
        $('#innerContent').load('forms/matchtype.php?id=' + matchTypeID + '&case=edit');
    });
    $('.delete').click(function(){
        var matchTypeID = $(this).attr('rel');
        var dataString = 'matchTypeID=' + matchTypeID + '&deleteMatchType=True';
        $.ajax({
            type: "POST",
            url: "processes/matchtype.php",
            data: dataString,
        });
        var table = $(this).closest("table");
        if (table.find("tr").length == 3) {
            table.remove();
        } else {
            $(this).closest("tr").remove();
        } 
    });                                             
});
</script>

<!-- Title -->
<div id="title" class="b2">
<h2>Match Types</h2>
<!-- TitleActions -->
<div id="titleActions">
<!-- ListSearch -->
<div class="listSearch actionBlock">
<div class="search">
<label for="search">Recherche</label>
<input type="text" name="search" id="search" class="text" />
</div>
<div class="submit">
<button type="submit" id="search-button" class="button"><strong><img src="img/icons/search_48.png" alt="comments" class="icon "/></strong></button>
</div>
</div>
<!-- /ListSearch -->
<!-- newPost -->
<div id="addform" class="newPost actionBlock">
<a href="#" id="matchtype" class="button"><strong>Add New Match Type<img src="img/icons/add_48.png" alt="new post" class="icon "/></strong></a>
</div>
<!-- /newPost -->
</div>
<!-- /TitleActions -->
</div>
<!-- Title -->
<!-- Inner Content -->
<div id="innerContent">
    <!-- ListHeader -->
<div id="listHeader">
<p class="listInfos">
You have <?php echo $rows; ?> match types.
</p>
</div>
<!-- /ListHeader -->
    <!-- ListTable -->
    <?php if ($rows > 0) { ?>
    <table cellspacing="0" class="listTable" id="matchTypesPageList">
    <!-- Thead -->
    <thead>
    <tr>
    <th class="first"><div><a href="#" title="Match Type Name">Match Type Name</a></div></th>
    <th><a href="#" title="Creator">Creator</a></th>
    <th><a href="#" title="Date Created">Date Created</a></th>
                    <th class="last">Edit/Delete</th>
    </tr>
    </thead>
    <!-- /Thead -->
    <!-- Tfoot -->
    <tfoot>
    <tr>
    <td colspan="4">
    <div class="inner">
    <div class="paginate">
                                <?php
if( $pages > 1 ) {
for( $i = 1; $i <= $pages; $i++ ) {
echo '<span style="padding-left: 5px; padding-right: 5px;"><a class="pageLink" href="#">' . $i . '</a></span>';
}
}
   ?>
    </div>
    </div>
    </td>
    </tr>
    </tfoot>
    <!-- /Tfoot -->
    <!-- Tbody -->
            <tbody>
    <?php 
        while ( $row = mysqli_fetch_array ( $result, MYSQL_ASSOC ) ) {
              echo '
              <tr>
       <td>' . $row['matchType'] . '</td>
       <td>' . $row['name'] . '</td>
       <td>' . $row['dateCreated'] . '</td>
                  <td style="text-align:center;"><img src="img/notepad.png" class="edit" rel="' . $row['ID'] . '"/><img src="img/Delete-icon.png" class="delete" rel="' . $row['ID'] . '"/></td>
  </tr>';
            }
            ?>
    </tbody>
    <!-- /Tbody -->
    </table>
        <?php
        }
        ?>
<!-- /ListTable -->
</div>
<!-- /Inner Content -->

I am building my uncle an online music catalogue and am trying to use pagination http://www.phpeasycode.com/pagination/ but for some reason it is only showing the cat_id data from the databse and even then its only the last entry.

I need it to show all cat_id, song, artist and year from the database and not just the same ones over and over again.

Here is a link to the page so you can see whats happening: http://www.nealeweb.com/steven2/

And here is the code, Can anybody tell me where i have gone wrong please.
Code: [Select]
$rpp = 24; // results per page
$adjacents = 4;

$page = intval($_GET["page"]);
if($page<=0) $page = 1;

$reload = $_SERVER['PHP_SELF'];

// connect to your DB:
$dbHost = "";
$dbUser = "";
$dbPass = "";
$dbname = "";

$db = mysql_connect($dbHost,$dbUser,$dbPass);
mysql_select_db($dbname,$db);

// select appropriate results from DB:
$requete = "SELECT cat_id, song, artist, year FROM tracks ORDER BY cat_id asc";
$result = mysql_query ($requete,$db);

// count total number of appropriate listings:
$tcount = mysql_num_rows($result);

// count number of pages:
$tpages = ($tcount) ? ceil($tcount/$rpp) : 1; // total pages, last page number

$count = 0;
$i = ($page-1)*$rpp;
while(($count<$rpp) && ($i<$tcount)) {
    mysql_data_seek($result,$i);
    $query = mysql_fetch_array($result);

    // output each row:
    echo'<tr>
                        <td valign="top" width="112" height="27"><span class="font">'.$catno.'</span></td>
                        <td valign="top" width="536" height="27"><span class="font">'.$songname.'</span></td>
                        <td valign="top"><span class="font" height="27">'.$artistname.'</span></td>
                        <td valign="top" width="80" height="27"><span class="font">'.$ryear.'</span></td>
                    </tr>';

    $i++;
    $count++;
}

// call pagination function:
include("paginate.php");
echo paginate_three($reload, $page, $tpages, $adjacents); 

i have some code which checks all of the posts in the database with the topic_id of $topic_id.

what i want to do is like on many forums. On the topic list next to the name just show the pages like:

Code: [Select]
1-2-3-4
and when there are more than 4 or so

Code: [Select]
1-2....8-9
here is the code which gets the number of pages:

$data = $db->query("SELECT * FROM
                    ".DB_PREFIX."posts
                    WHERE topic_id = '$topic_info->topic_id'");
 $rows = mysql_num_rows($data); 
 $page_rows = $posts_per_page; 
 
 if ($rows > $page_rows) {
 
 $rowsArray = array($rows);
 
 }

as you can see i have added it into an array but i dont know what to do from there. I guessed it would be something like a for statement but im not sure. Can anyone help?

Hello,

I am trying to incorporate pagination to only show 20 rows per page but instead the links work but shows all rows on all pages.
Link to see: http://webjax.99k.org/

Full Code:

Code: [Select]
<?php
include ("./header.php");

//PAGINATION

$sql = "SELECT COUNT(*) FROM servers";
$result = mysql_query($sql) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];

// number of rows to show per page

$rowsperpage = 20;
// find out total pages
$totalpages = ceil($numrows / $rowsperpage);

// get the current page or set a default
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
   // cast var as int
   $currentpage = (int) $_GET['currentpage'];
} else {
   // default page num
   $currentpage = 1;
} // end if

// if current page is greater than total pages...
if ($currentpage > $totalpages) {
   // set current page to last page
   $currentpage = $totalpages;
} // end if
// if current page is less than first page...
if ($currentpage < 1) {
   // set current page to first page
   $currentpage = 1;
} // end if

// the offset of the list, based on current page 
$offset = ($currentpage - 1) * $rowsperpage;

//END PAGINATION


//======================================================================== Commands
If (isSet($_GET['sort']))
{
$sortby = $_GET['sort'];
If ($sortby=='name' || $sortby=='ip' || $sortby=='votes' || $sortby=='username')
{
If ($sortby=='name')
{
$options = "<option value='./index.php?sort=name' selected='selected'>Name</option>
<option value='./index.php?sort=ip'>IP Address</option>
<option value='./index.php?sort=votes'>Rank</option>
<option value='./index.php?sort=username'>Owner</option>";
}
If ($sortby=='ip')
{
$options = "<option value='./index.php?sort=name'>Name</option>
<option value='./index.php?sort=ip' selected='selected'>IP Address</option>
<option value='./index.php?sort=votes'>Rank</option>
<option value='./index.php?sort=username'>Owner</option>";
}
If ($sortby=='votes')
{
$options = "<option value='./index.php?sort=name'>Name</option>
<option value='./index.php?sort=ip'>IP Address</option>
<option value='./index.php?sort=votes' selected='selected'>Rank</option>
<option value='./index.php?sort=username'>Owner</option>";
}
If ($sortby=='username')
{
$options = "<option value='./index.php?sort=name'>Name</option>
<option value='./index.php?sort=ip'>IP Address</option>
<option value='./index.php?sort=votes'>Rank</option>
<option value='./index.php?sort=username' selected='selected'>Owner</option>";
}
}
else
{
$sortby = "votes";
$options = "<option value='./index.php?sort=name'>Name</option>
<option value='./index.php?sort=ip'>IP Address</option>
<option value='./index.php?sort=votes' selected='selected'>Rank</option>
<option value='./index.php?sort=username'>Owner</option>";
}
}
else
{
$sortby = "votes";
$options = "<option value='./index.php?sort=name'>Name</option>
<option value='./index.php?sort=ip'>IP Address</option>
<option value='./index.php?sort=votes' selected='selected'>Rank</option>
<option value='./index.php?sort=username'>Owner</option>";
}
If ($_GET['act']=='see' && isSet($_GET['id']))
{
//=================================================================== XSS protection
$sid = str_replace("/", "", $_GET['id']);
$sid = str_replace(Chr(92), "", $sid);
$sid = str_replace("'", "", $sid);
$sid = str_replace('"', "", $sid);
$sid = str_replace("<", "", $sid);
$sid = str_replace(">", "", $sid);
$sid = str_replace("-", "", $sid);
$sid = str_replace("union", "", $sid);
$sid = str_replace("information_schema", "", $sid);
$sid = strtolower(trim($sid));
//=================================================================== XSS protection
$result = mysql_query("SELECT * FROM servers WHERE id='$sid'") or die (mysql_error());
$nr = mysql_num_rows($result);
If ($nr<='0')
{
$exist = "No";
}
else
{
$exist = "Yes";
while($row = mysql_fetch_array($result))
{
If ($row['name']=='')
{
$servername = "<img src='./banners/" .$row['banner']. "' style='width:468px;height:60px' title='Server details'>";
}
else
{
$servername = $row['name'];
}
$did = $row['id'];
$dname  = $row['name'];
$dbanner  = $row['banner'];
$dip  = $row['ip'];
$ddescription  = $row['description'];
$dwebsite  = $row['website'];
$dcountry  = $row['country'];
$dsponsored  = $row['sponsored'];
$dvotes  = $row['votes'];
$mineq = $row['mineq'];
$dusername  = $row['username'];
$ddate  = $row['date'];
If ($dusername==$username)
{
$me = "Yes";
}
else
{
$me = "No";
}
If ($mineq=='Yes')
{
If (!$dip=='')
{
include ("./minequery.class.php");
$mine  = array((Minequery::query($dip)));
$donlinep  = $mine["0"]["playerCount"];
If ($donlinep>0)
{
for ($i = 0; $i <= $donlinep; $i++)
{
$playername = $mine["0"]["playerList"][$i];
If (!$playername=='')
{
$donline .= $playername. ", ";
}
}
$donline = left($donline, strlen($donline)-2);
}
}
else
{
$donline  = "<i>n/a</i>";
}
}
else
{
$donline  = "<i>n/a</i>";
}
}
}
}
If ($_GET['act']=='' || $_GET['act']=='sponsored' || $_GET['act']=='myservers')
{
$result = mysql_query("SELECT * FROM servers ORDER BY votes DESC") or die (mysql_error());
while($rk_list[] = mysql_fetch_array($result));
If (isSet($username) && $_GET['act']=='myservers')
{
$result = mysql_query("SELECT * FROM servers WHERE username='$username' ORDER BY id DESC") or die (mysql_error());
}
else
{
If ($_GET['act']=='sponsored')
{
$result = mysql_query("SELECT * FROM servers WHERE sponsored='Yes' ORDER BY id DESC") or die (mysql_error());
}
else
{
If (isSet($_GET['country']))
{
$result = mysql_query("SELECT * FROM servers WHERE country='$_GET[country]' ORDER BY votes DESC") or die (mysql_error());
}
else
{
$result = mysql_query("SELECT * FROM servers ORDER BY $sortby DESC") or die (mysql_error());
}
}
}
$nr = mysql_num_rows($result);
If ($nr<='0')
{
$serverslist = "<tr><td align='center' colspan='6'>There are no servers added yet !</td></tr>";
}
else
{
include ("./minequery.class.php");
$rank = "0";
while($row = mysql_fetch_array($result)){
$data[] = $row; }
foreach ($data as $row)
{
$rank = ($rank + 1);
If ($row['banner']=='')
{
$servername = $row['name'];
}
else
{
$servername = "<img src='" .$row['banner']. "' style='width:400px;height:60px' title='Server details'>";
}
If ($row['sponsored']=='Yes')
{
$star = "style='background:url(./images/star.png);background-repeat:no-repeat;'";
}
else
{
$star = "";
}
If ($row['mineq']=='Yes')
{
If (!$row['ip']=='')
{
$mine  = array((Minequery::query($row['ip'])));
$onlinep  = $mine["0"]["playerCount"];
}
else
{
$onlinep = "<i>n/a</i>";
}
}
else
{
$onlinep = "<i>n/a</i>";
}
$country = "./flags/" .$row['country']. ".png";
$serverslist .= "<tr><td align='center'>" .(array_search($row, $rk_list) + 1). "</td><td align='center'><a href='./index.php?country=" .$row['country']. "'><img src='" .$country. "' title='" .$row['country']. "' style='width:32px;height:32px;'></a></td><td align='center' valign='middle' style='height:60px;'><a class='nav' href='./index.php?act=see&id=" .$row['id']. "' title='Server details'>" .$servername. "</a></td><td align='center' " .$star. ">" .$row['ip']. "</td><td align='center'>" .$onlinep. "</td><td align='center'>" .$row['votes']. "</td></tr>";
//$serverslist .= "<tr><td align='center'>" .$row['id']. "</td><td align='center' valign='middle' style='height:60px;'><a class='nav' href='./index.php?act=see&id=" .$row['id']. "' title='Server details'>" .$servername. "</a></td><td align='center'><img src='./flags/" .$row['country']. ".ico' title='" .$row['country']. "'> " .$row['ip']. "</td><td align='center'>" .$row['votes']. "</td><td align='center'>" .$row['date']. "</td></tr>";
//$serverslist .= "<tr><td align='center'>" .$row['id']. "</td><td align='center'>" .$servername. "</td><td align='center'>" .country_flag($row['ip']). " " .$row['ip']. "</td><td align='center'>" .$row['votes']. "</td></tr>";
}
}
}

/******  build the pagination links ******/
// range of num links to show
$range = 3;

// if not on page 1, don't show back links
if ($currentpage > 1) {
   // show << link to go back to page 1
   echo " <a href='./{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";
   // get previous page num
   $prevpage = $currentpage - 1;
   // show < link to go back to 1 page
   echo " <a href='./{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
} // end if 

// loop to show links to range of pages around current page
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
   // if it's a valid page number...
   if (($x > 0) && ($x <= $totalpages)) {
      // if we're on current page...
      if ($x == $currentpage) {
         // 'highlight' it but don't make a link
         echo " [<b>$x</b>] ";
      // if not current page...
      } else {
         // make it a link
         echo " <a href='./{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
      } // end else
   } // end if 
} // end for
                 
// if not on last page, show forward and last page links        
if ($currentpage != $totalpages) {
   // get next page
   $nextpage = $currentpage + 1;
    // echo forward link for next page 
   echo " <a href='./{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";
   // echo forward link for lastpage
   echo " <a href='./{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";
} // end if
/****** end build pagination links ******/

//======================================================================== Strings
$countries =  "<option>Afghanistan</option>
<option>Albania</option>
<option>Algeria</option>
<option>Andorra</option>
<option>Angola</option>
<option>Antigua and Barbuda</option>
<option>Argentina</option>
<option>Armenia</option>
<option>Aruba</option>
<option>Australia</option>
<option>Austria</option>
<option>Azerbaijan</option>
<option>Bahamas, The</option>
<option>Bahrain</option>
<option>Bangladesh</option>
<option>Barbados</option>
<option>Belarus</option>
<option>Belgium</option>
<option>Belize</option>
<option>Benin</option>
<option>Bermuda</option>
<option>Bhutan</option>
<option>Bolivia</option>
<option>Bosnia and Herzegovina</option>
<option>Botswana</option>
<option>Brazil</option>
<option>Brunei</option>
<option>Bulgaria</option>
<option>Burkina Faso</option>
<option>Burma</option>
<option>Burundi</option>
<option>Cambodia</option>
<option>Cameroon</option>
<option>Canada</option>
<option>Cape Verde</option>
<option>Cayman Islands</option>
<option>Central African Republic</option>
<option>Chad</option>
<option>Chile</option>
<option>China</option>
<option>Colombia</option>
<option>Comoros</option>
<option>Congo, Democratic Republic of the</option>
<option>Congo, Republic of the</option>
<option>Costa Rica</option>
<option>Cote d'Ivoire</option>
<option>Croatia</option>
<option>Cuba</option>
<option>Curacao</option>
<option>Cyprus</option>
<option>Czech Republic</option>
<option>Denmark</option>
<option>Djibouti</option>
<option>Dominica</option>
<option>Dominican Republic</option>
<option>Ecuador</option>
<option>Egypt</option>
<option>El Salvador</option>
<option>Equatorial Guinea</option>
<option>Eritrea</option>
<option>Estonia</option>
<option>Ethiopia</option>
<option>Fiji</option>
<option>Finland</option>
<option>France</option>
<option>Gabon</option>
<option>Gambia</option>
<option>Georgia</option>
<option>Germany</option>
<option>Ghana</option>
<option>Greece</option>
<option>Grenada</option>
<option>Guatemala</option>
<option>Guinea</option>
<option>Guinea-Bissau</option>
<option>Guyana</option>
<option>Haiti</option>
<option>Holy See</option>
<option>Honduras</option>
<option>Hong Kong</option>
<option>Hungary</option>
<option>Iceland</option>
<option>India</option>
<option>Indonesia</option>
<option>Iran</option>
<option>Iraq</option>
<option>Ireland</option>
<option>Israel</option>
<option>Italy</option>
<option>Jamaica</option>
<option>Japan</option>
<option>Jordan</option>
<option>Kazakhstan</option>
<option>Kenya</option>
<option>Kiribati</option>
<option>Kosovo</option>
<option>Kuwait</option>
<option>Kyrgyzstan</option>
<option>Laos</option>
<option>Latvia</option>
<option>Lebanon</option>
<option>Lesotho</option>
<option>Liberia</option>
<option>Libya</option>
<option>Liechtenstein</option>
<option>Lithuania</option>
<option>Luxembourg</option>
<option>Macau</option>
<option>Macedonia</option>
<option>Madagascar</option>
<option>Malawi</option>
<option>Malaysia</option>
<option>Maldives</option>
<option>Mali</option>
<option>Malta</option>
<option>Marshall Islands</option>
<option>Mauritania</option>
<option>Mauritius</option>
<option>Mexico</option>
<option>Micronesia</option>
<option>Moldova</option>
<option>Monaco</option>
<option>Mongolia</option>
<option>Montenegro</option>
<option>Morocco</option>
<option>Mozambique</option>
<option>Namibia</option>
<option>Nauru</option>
<option>Nepal</option>
<option>Netherlands</option>
<option>Netherlands Antilles</option>
<option>New Zealand</option>
<option>Nicaragua</option>
<option>Niger</option>
<option>Nigeria</option>
<option>North Korea</option>
<option>Norway</option>
<option>Oman</option>
<option>Pakistan</option>
<option>Palau</option>
<option>Panama</option>
<option>Papua New Guinea</option>
<option>Paraguay</option>
<option>Peru</option>
<option>Philippines</option>
<option>Poland</option>
<option>Portugal</option>
<option>Qatar</option>
<option>Romania</option>
<option>Russia</option>
<option>Rwanda</option>
<option>Saint Kitts and Nevis</option>
<option>Saint Lucia</option>
<option>Saint Vincent and the Grenadines</option>
<option>Samoa</option>
<option>San Marino</option>
<option>Sao Tome and Principe</option>
<option>Saudi Arabia</option>
<option>Senegal</option>
<option>Serbia</option>
<option>Seychelles</option>
<option>Sierra Leone</option>
<option>Singapore</option>
<option>Slovakia</option>
<option>Slovenia</option>
<option>Solomon Islands</option>
<option>Somalia</option>
<option>South Africa</option>
<option>South Korea</option>
<option>South Sudan</option>
<option>Spain</option>
<option>Sri Lanka</option>
<option>Sudan</option>
<option>Suriname</option>
<option>Swaziland</option>
<option>Sweden</option>
<option>Switzerland</option>
<option>Syria</option>
<option>Taiwan</option>
<option>Tajikistan</option>
<option>Tanzania</option>
<option>Thailand</option>
<option>Timor-Leste</option>
<option>Togo</option>
<option>Tonga</option>
<option>Trinidad and Tobago</option>
<option>Tunisia</option>
<option>Turkey</option>
<option>Turkmenistan</option>
<option>Tuvalu</option>
<option>Uganda</option>
<option>Ukraine</option>
<option>United Arab Emirates</option>
<option>United Kingdom</option>
<option>Uruguay</option>
<option>Uzbekistan</option>
<option>Vanuatu</option>
<option>Venezuela</option>
<option>Vietnam</option>
<option>Yemen</option>
<option>Zambia</option>
<option>Zimbabwe</option>";
$servers =  "<table align='center' class='fancy' width='100%'>
<tr><th align='left' colspan='6'>Servers list</th></tr>
<tr><td align='left' colspan='3'>Servers : " .$nr. "</td><td align='right' colspan='3'>Arrange by : <select name='by' onChange=location.href=this.options[this.selectedIndex].value;>" .$options. "</select></td></tr>
<tr><th align='center' width='1%'>#</th><th align='center' width='1%'>Country</th><th align='center' width='47%'>Name / Banner</th><th align='center' width='20%'>IP Address</th><th align='center' width='1%'>Players Online</th><th align='center' width='1%'>Votes</th></tr>
" .$serverslist. "
</table>";
$addsv  = "<table align='center' class='fancy' width='100%'>
<tr><th align='left' colspan='2'>Add server</th></tr>
<tr><td align='left' width='100px'>Name :</td><td align='left'><input class='field' type='text' name='aname' style='width:100%;'></td></tr>
<tr><td align='left'>Banner url :</td><td align='left'><input class='field' type='text' name='abanner' style='width:100%;'></td></tr>
<tr><td align='left'>Description :</td><td align='left'><textarea class='textarea' name='adescription'></textarea></td></tr>
<tr><td align='left'>IP Address :</td><td align='left'><input class='field' type='text' name='aip'></td></tr>
<tr><td align='left'>Website :</td><td align='left'><input class='field' type='text' name='awebsite'></td></tr>
<tr><td align='left'>Country :</td><td align='left'><select name='acountry'>" .$countries. "</select></td></tr>
<tr><td align='left'>MineQuery :</td><td align='left'><select name='amine'><option selected='selected'>Yes</option><option>No</option></select></td></tr>
<tr><td align='left'>Captcha :</td><td align='left'><img src='./captcha.php' title='Captcha'> <input class='field' type='text' name='captcha' style='width:100px;' maxlength='5'></td></tr>
<tr><td>&nbsp;</td><td align='left'><input type='submit' name='aok' value='Add'></td></tr>
</table>";
$login =  "<table align='left' class='fancy' width='40%'>
<tr><th align='left' colspan='2'>Login</th></tr>
<tr><td align='left' width='30%'>Username :</td><td align='left'><input class='field' type='text' name='lname'></td></tr>
<tr><td align='left'>Password :</td><td align='left'><input class='field' type='password' name='lpass'></td></tr>
<tr><td>&nbsp;</td><td align='left'><input type='submit' name='lok' value='Login'></td></tr>
</table>";
$register = "<table align='left' class='fancy' width='45%'>
<tr><th align='left' colspan='2'>Register</th></tr>
<tr><td align='left' width='30%'>Username :</td><td align='left'><input class='field' type='text' name='rname'> <font color='red'>*</font></td></tr>
<tr><td align='left'>E-mail :</td><td align='left'><input class='field' type='text' name='rmail'> <font color='red'>*</font></td></tr>
<tr><td align='left'>Password :</td><td align='left'><input class='field' type='password' name='rpass'> <font color='red'>*</font></td></tr>
<tr><td align='left'>Re-Password :</td><td align='left'><input class='field' type='password' name='rrepass'> <font color='red'>*</font></td></tr>
<tr><td>&nbsp;</td><td align='left'><input type='submit' name='rok' value='Register'></td></tr>
</table>";
$settings = "<table align='left' class='g' width='80%'>
<tr><th align='left' colspan='2'>Settings</th></tr>
<tr><td width='50%' valign='top'>
<table align='left' class='fancy' width='100%'>
<tr><th align='left' colspan='2'>My account</th></tr>
<tr><td align='left'>E-mail : </td><td align='left'>" .$uemail. "</td></tr>
<tr><td align='left'>Servers : </td><td align='left'>" .$uservers. "</td></tr>
<tr><td align='left'>Next vote : </td><td align='left'>" .$unextvoted. "</td></tr>
<tr><td align='left'>Join date : </td><td align='left'>" .$udate. "</td></tr>
</table>
</td><td width='50%' valign='top'>
<table align='left' class='fancy' width='100%'>
<tr><th align='left' colspan='2'>Change password</th></tr>
<tr><td align='left'>Current password : </td><td align='left'><input type='password' name='cpass'></td></tr>
<tr><td align='left'>New password : </td><td align='left'><input type='password' name='cnpass'></td></tr>
<tr><td align='left'>New re-password : </td><td align='left'><input type='password' name='cnrepass'></td></tr>
<tr><td>&nbsp;</td><td align='left'><input type='submit' name='cok' value='Change'></td></tr>
</table>
</td></tr>
</table>";
$f = fopen("./mine.txt", "r");
while ($line = fgets($f, 9999))
{
$minetext .= $line. "";
}
fclose($f);
$minequery = "<table align='left' class='fancy' width='100%'>
<tr><th align='left' colspan='2'>MineQuery</th></tr>
<tr><td align='left'>
" .$minetext. "
</td></tr>
</table>";
$f = fopen("./help.txt", "r");
while ($line = fgets($f, 9999))
{
$helptext .= $line. "";
}
fclose($f);
$help = "<table align='left' class='fancy' width='100%'>
<tr><th align='left' colspan='2'>Help</th></tr>
<tr><td align='left'>
" .$helptext. "
</td></tr>
</table>";
If ($me=='No')
{
If ($dname=='')
{
$dname = "<i>none</i>";
}
If ($dbanner=='')
{
$dbanner = "<i>none</i>";
}
else
{
$dbanner = "<img src='" .$dbanner. "' title='Banner' style='width:468px;height:60px'>";
}
$details = "<table align='center' class='fancy' width='100%'>
<tr><th align='left' colspan='2'>Server details</th></tr>
<tr><td align='left' width='100px'>Name :</td><td align='left'>" .$dname. "</td></tr>
<tr><td align='left'>Banner url :</td><td align='left'>" .$dbanner. "</td></tr>
<tr><td align='left'>Description :</td><td align='left'>" .$ddescription. "</td></tr>
<tr><td align='left'>Players online :</td><td align='left'>" .$donline. "</td></tr>
<tr><td align='left'>IP Address :</td><td align='left'>" .$dip. "</td></tr>
<tr><td align='left'>Website :</td><td align='left'>" .$dwebsite. "</td></tr>
<tr><td align='left'>Sponsored :</td><td align='left'>" .$dsponsored. "</td></tr>
<tr><td align='left'>Votes :</td><td align='left'>" .$dvotes. "</td></tr>
<tr><td align='left'>Owner :</td><td align='left'>" .$dusername. "</td></tr>
<tr><td align='left'>Added at :</td><td align='left'>" .$ddate. "</td></tr>
<tr><td align='left'>Vote link :</td><td align='left'><a class='nav' href='" .$siteurl. "/vote.php?id=" .$did. "' title='Vote link'>" .$siteurl. "/vote.php?id=" .$did. "</td></tr>
</table>";
}
else
{
$details = "<table align='center' class='fancy' width='100%'>
<tr><th align='left' colspan='2'>Server details</th></tr>
<tr><td align='left' width='100px'>Name :</td><td align='left'><input class='field' type='text' name='nname' style='width:700px;' value='" .$dname. "'></td></tr>
<tr><td align='left'>Banner url :</td><td align='left'><input class='field' type='text' name='nbanner' style='width:700px;' value='" .$dbanner. "'></td></tr>
<tr><td align='left'>Description :</td><td align='left'><textarea class='textarea' name='ndescription'>" .$ddescription. "</textarea></td></tr>
<tr><td align='left'>Players online :</td><td align='left'>" .$donline. "</td></tr>
<tr><td align='left'>IP Address :</td><td align='left'><input class='field' type='text' name='nip' value='" .$dip. "'></td></tr>
<tr><td align='left'>Website :</td><td align='left'><input class='field' type='text' name='nwebsite' value='" .$dwebsite. "'></td></tr>
<tr><td align='left'>Vote link :</td><td align='left'><a class='nav' href='" .$siteurl. "/vote.php?id=" .$did. "' title='Vote link'>" .$siteurl. "/vote.php?id=" .$did. "</td></tr>
<tr><td>&nbsp;</td><td align='left'><input type='submit' name='dok' value='Update'> <input type='submit' name='delok' value='Delete'></td></tr>
</table>";
}
//======================================================================== Display
echo "<form method='post' action='" .curPageURL(). "' style='margin:0px;'>";
If ($sidebar=="Yes")
{
echo  "<table align='center' width='100%'>
<tr><td align='left' width='80%' valign='top'>";
}
If ($_GET['act']=='add' || $_GET['act']=='see' || $_GET['act']=='login' || $_GET['act']=='register' || $_GET['act']=='settings' || $_GET['act']=='myservers' || $_GET['act']=='minequery' || $_GET['act']=='help')
{
If ($_GET['act']=='add')
{
If (!$_SESSION['user']=='')
{
echo $addsv;
}
else
{
echo $login;
}
}
If ($_GET['act']=='login')
{
If ($_SESSION['user']=='')
{
echo $login;
}
else
{
echo $servers;
}
}
If ($_GET['act']=='register')
{
If ($_SESSION['user']=='')
{
echo $register;
}
else
{
echo $servers;
}
}
If ($_GET['act']=='see')
{
If ($exist=='Yes')
{
echo $details;
}
else
{
echo $servers;
}
}
If ($_GET['act']=='settings')
{
If ($_SESSION['user']=='')
{
echo $login;
}
else
{
echo $settings;
}
}
If ($_GET['act']=='myservers')
{
echo $servers;
}
If ($_GET['act']=='minequery')
{
echo $minequery;
}
If ($_GET['act']=='help')
{
echo $help;
}
}
else
{
echo $servers;
}
If ($sidebar=="Yes")
{
echo  "</td><td align='right' width='20%' valign='top'>
<table align='center' width='100%' class='fancy'>
" .$rsidead. "
</table>
</td></tr>
</table>";
}
echo "</form>";
include ("./footer.php");
?>
this is where I tried to put pagination in:
Code: [Select]
If ($_GET['act']=='' || $_GET['act']=='sponsored' || $_GET['act']=='myservers')
{
$result = mysql_query("SELECT * FROM servers ORDER BY votes DESC") or die (mysql_error());
while($rk_list[] = mysql_fetch_array($result));
If (isSet($username) && $_GET['act']=='myservers')
{
$result = mysql_query("SELECT * FROM servers WHERE username='$username' ORDER BY id DESC") or die (mysql_error());
}
else
{
If ($_GET['act']=='sponsored')
{
$result = mysql_query("SELECT * FROM servers WHERE sponsored='Yes' ORDER BY id DESC") or die (mysql_error());
}
else
{
If (isSet($_GET['country']))
{
$result = mysql_query("SELECT * FROM servers WHERE country='$_GET[country]' ORDER BY votes DESC") or die (mysql_error());
}
else
{
$result = mysql_query("SELECT * FROM servers ORDER BY $sortby DESC") or die (mysql_error());
}
}
}
$nr = mysql_num_rows($result);
If ($nr<='0')
{
$serverslist = "<tr><td align='center' colspan='6'>There are no servers added yet !</td></tr>";
}
else
{
include ("./minequery.class.php");
$rank = "0";
while($row = mysql_fetch_array($result)){
$data[] = $row; }
foreach ($data as $row)
{
$rank = ($rank + 1);
If ($row['banner']=='')
{
$servername = $row['name'];
}
else
{
$servername = "<img src='" .$row['banner']. "' style='width:400px;height:60px' title='Server details'>";
}
If ($row['sponsored']=='Yes')
{
$star = "style='background:url(./images/star.png);background-repeat:no-repeat;'";
}
else
{
$star = "";
}
If ($row['mineq']=='Yes')
{
If (!$row['ip']=='')
{
$mine = array((Minequery::query($row['ip'])));
$onlinep = $mine["0"]["playerCount"];
}
else
{
$onlinep = "<i>n/a</i>";
}
}
else
{
$onlinep = "<i>n/a</i>";
}
$country = "./flags/" .$row['country']. ".png";
$serverslist .= "<tr><td align='center'>" .(array_search($row, $rk_list) + 1). "</td><td align='center'><a href='./index.php?country=" .$row['country']. "'><img src='" .$country. "' title='" .$row['country']. "' style='width:32px;height:32px;'></a></td><td align='center' valign='middle' style='height:60px;'><a class='nav' href='./index.php?act=see&id=" .$row['id']. "' title='Server details'>" .$servername. "</a></td><td align='center' " .$star. ">" .$row['ip']. "</td><td align='center'>" .$onlinep. "</td><td align='center'>" .$row['votes']. "</td></tr>";
//$serverslist .= "<tr><td align='center'>" .$row['id']. "</td><td align='center' valign='middle' style='height:60px;'><a class='nav' href='./index.php?act=see&id=" .$row['id']. "' title='Server details'>" .$servername. "</a></td><td align='center'><img src='./flags/" .$row['country']. ".ico' title='" .$row['country']. "'> " .$row['ip']. "</td><td align='center'>" .$row['votes']. "</td><td align='center'>" .$row['date']. "</td></tr>";
//$serverslist .= "<tr><td align='center'>" .$row['id']. "</td><td align='center'>" .$servername. "</td><td align='center'>" .country_flag($row['ip']). " " .$row['ip']. "</td><td align='center'>" .$row['votes']. "</td></tr>";
}
}
}

/******  build the pagination links ******/
// range of num links to show
$range = 3;

// if not on page 1, don't show back links
if ($currentpage > 1) {
   // show << link to go back to page 1
   echo " <a href='./{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";
   // get previous page num
   $prevpage = $currentpage - 1;
   // show < link to go back to 1 page
   echo " <a href='./{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
} // end if

// loop to show links to range of pages around current page
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
   // if it's a valid page number...
   if (($x > 0) && ($x <= $totalpages)) {
      // if we're on current page...
      if ($x == $currentpage) {
         // 'highlight' it but don't make a link
         echo " [<b>$x</b>] ";
      // if not current page...
      } else {
         // make it a link
         echo " <a href='./{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
      } // end else
   } // end if
} // end for
                 
// if not on last page, show forward and last page links       
if ($currentpage != $totalpages) {
   // get next page
   $nextpage = $currentpage + 1;
    // echo forward link for next page
   echo " <a href='./{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";
   // echo forward link for lastpage
   echo " <a href='./{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";
} // end if
/****** end build pagination links ******/
I'm not sure what im doing wrong can anyone help?