W3Sidan.net

  <?php
  $limit = 15; // Antal per sida 
  $result = @mysql_query("SELECT count(*) as count FROM fam") 
  or die("Error fetching number in DB<br>".mysql_error()); 
  $row = @mysql_fetch_array($result); 
  $numrows = $row['count']; // Antal i databasen 
  if (!isset($_GET['start']) || $_GET['start'] == "") 
  $start = 0; 
  else 
  $start = $_GET['start']; 
  $pages = intval($numrows/$limit); 
  if ($numrows%$limit) 
  $pages++; 
  for ($i = 1; $i <= $pages; $i++) { 
  $newoffset = $limit*($i - 1); 
  if ($start == $newoffset) 
  $numlink .= '<a href="?show=fam&start=0"><u>'.$i.'</u></a>&nbsp;&nbsp;'; 
  else 
  $numlink .= '<a href="?show=fam&start='.$newoffset.'">'.$i.'</a>&nbsp;&nbsp;'; 
  } 
  ?>
  <?php
  $sql = "SELECT * FROM fam ORDER by popularity DESC limit ".$start.",".$limit."";
  $result = mysql_query($sql);
  $i = 1;
  while($rad = mysql_fetch_array($result)){
  $color = ($color == "#ffffff") ? "#f6f6f6" : "#ffffff";
  ?>
        <tr bgcolor="<?php echo "$color"; ?>">
          <td style="padding: 5px;font-size: 25px;color: #efefef;"><?php echo $i; $i++; ?></td>