<?php
$host="HOSTz";
$username="USERNAEMz";
$password="PASSWORDz";
$database="DATABASEz";

mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$rowsPerPage = 10;
$pageNum = 1;

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


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

$query = " SELECT * FROM smf_members ORDER BY steamid DESC " .
         " LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed');
?>
<style type="text/css">
            table.fancy {
              margin: 1em 1em 1em 0;
              background: whitesmoke;
              border-collapse: collapse;
            }
            table.fancy tr:hover {
               background: lightsteelblue !important;
            }
            table.fancy th, table.fancy td {
              border: 1px silver solid;
              padding: 0.2em;
            }
            table.fancy th {
              background: gainsboro;
              text-align: left;
            }
            table.fancy caption {
              margin-left: inherit;
              margin-right: inherit;
            }
</style>
<table class="fancy"><center>
<tr>
            <th width="25%"><center>ID</center></th>
            <th width="15%"><center>SteamID</center></th>
            <th width="25%"><center>Name</center></th>
</tr></center>
<?php


while($row = mysql_fetch_array($result))
{
   echo "<tr>";
   $ID_MEMBER = $row['ID_MEMBER'];
   $STEAMID = $row['steamid'];
   $NAME = $row['realName'];
                    if ($STEAMID != ''){
                        echo "<td><font face=\"Arial, Helvetica, sans-serif\"><center>";
                        echo $ID_MEMBER;
                        echo "</center></font></td>";
                        echo "<td><font face=\"Arial, Helvetica, sans-serif\"><center>";
                        echo $STEAMID;
                        echo "</center></font></td>";
                        echo "<td><font face=\"Arial, Helvetica, sans-serif\"><center>";
                        echo $NAME;
                        echo "</center></td>";
                    }
                    else{
                        echo "<td><font face=\"Arial, Helvetica, sans-serif\"><center>";
                        echo $ID_MEMBER;
                        echo "</center></font></td>";
                        echo "<td><font face=\"Arial, Helvetica, sans-serif\"><center>";
                        echo "No SteamID entered.";
                        echo "</center></font></td>";
                        echo "<td><font face=\"Arial, Helvetica, sans-serif\"><center>";
                        echo $NAME;
                        echo "</center></td>";
                    }
echo "</tr>";

}




$query   = "SELECT COUNT(ID_MEMBER) AS numrows FROM smf_members";
$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\">$page</a> ";
   }
}

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

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

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

   $last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
}
else
{
   $next = '&nbsp;';
   $last = '&nbsp;';
}
echo $first . $prev . $nav . $next . $last;


?>