Pagination results

[graham23s]

Hi Guys,

 

i'm having a problem with my pagination links, i can limit the query ok,but i'm only seeing 1 link:

 

[1]

 

but i should see 2

 

[1][2]

 

<?php
  ## Pagination
  if(!isset($_GET['page'])){ 
    $page = 1; 
  } else { 
    $page = $_GET['page']; 
  } 
  
  ## results
  $perpage = 1;
  
  ## start index
  $from = (($page * $perpage) - $perpage);
        
  //======================== COMPILE QUERY ========================//
  $searchquery  = "SELECT * FROM `users` WHERE 1=1 ";
  
  ## GENDER #########################################################
  if(isset($gender) && ($gender != '0')) { 
  
  $searchquery .= "AND `gender`='$gender' "; 
  $addressbar .= "&gender=$gender";
  
  }
  ## HERE FOR #######################################################
  if(isset($herefor) && ($herefor != '0')) { 
  
  $searchquery .= "AND `herefor`='$herefor' "; 
  $addressbar .= "&herefor=$herefor";
  
  }  
  ## COUNTRY ########################################################
  if(isset($country) && ($country != '0')) { 
  
  $searchquery .= "AND `country`='$country' "; 
  $addressbar .= "&country=$country";
  
  }  
  ## ETHNICITY ######################################################
  if(isset($ethnicity) && ($ethnicity != '0')) { 
  
  $searchquery .= "AND `ethnic`='$ethnicity' "; 
  $addressbar .= "&ethnicity=$ethnicity";
  
  } 
  ## HAIR ###########################################################
  if(isset($hair) && ($hair != '0')) { 
  
  $searchquery .= "AND `hair`='$hair' "; 
  $addressbar .= "&hair=$hair";
  
  }  
  ## BUILD ##########################################################
  if(isset($build) && ($build != '0')) { 
  
  $searchquery .= "AND `build`='$build' "; 
  $addressbar .= "&build=$build";
  
  }    
  ## EYE_C ##########################################################
  if(isset($eyes) && ($eyes != '0')) { 
  
  $searchquery .= "AND `eye_c`='$eyes' "; 
  $addressbar .= "&eyes=$eyes";
  
  }     
  ## AGES ###########################################################
  $searchquery .= "AND `year` BETWEEN YEAR(CURDATE() - INTERVAL $toage YEAR) AND YEAR(CURDATE() - INTERVAL $fromage YEAR) LIMIT $from, $perpage";
  //======================== COMPILE QUERY ========================//
  
  ## run query
  $resultquery = mysql_query($searchquery);
  
  ## num results
  $numresults = mysql_num_rows($resultquery);
  
  ## no results
  if($numresults == 0) {

  echo ('<br /><span class="gallery_header">Sorry, no results were found!</span><br />');
  include("includes/footer.php");
  exit;
    
  } else {
   
  echo ('<br /><span class="gallery_header">We have found you <b>'.$numresults.'</b> matches!</span><br /><br />');
  
  while($row = mysql_fetch_array($resultquery)) {
  
  ## details
  $searchid = $row['id'];
  $searchusername = $row['username'];
  $searchthumb = $row['thumbnail'];
  
  $nopic = (!empty($searchthumb)) ? "<img src=\"thumbs/$searchthumb\">" : "<img src=\"images/noimgup.jpg\"";
   
  ## some results
  echo ("<table class=\"sub_table\" align=\"center\" width=\"300\" border=\"0\" cellpadding=\"5\" cellspacing=\"0\">");
  echo ("<tr>");
  echo ("<td class=\"sub_table\" align=\"center\">$nopic</td>");
  echo ("</tr>");
  echo ("</table>");
  echo ("<br />");  
  
  } // end while
  
  ## Pagination Links
  echo ("<div id=\"pagination\" align=\"left\">");
  echo ("<hr /><br />");
  
        // Figure out the total number of pages. Always round up using ceil() 
        $totalpages = ceil($numresults / $perpage); 
        
        // Build Previous Link 
        if($page > 1){ 
            $prev = ($page - 1); 
            echo " <a href=\"".$_SERVER['PHP_SELF']."?page=$prev$addressbar\">PREV </a> "; 
        } 
        
        for($i = 1; $i <= $totalpages; $i++){ 
            if(($page) == $i){ 
                echo "[<b>$i</b>] "; 
                } else { 
                    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i$addressbar\">$i</a> "; 
            } 
        } 
        
        // Build Next Link 
        if($page < $totalpages){ 
            $next = ($page + 1); 
            echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next$addressbar\">NEXT</a>"; 
        } 
        
  echo ("</div>");    
  
  }
  
  } // end if
?>

 

any help on this would be great

 

thanks

 

Graham

[razzle]

i just had the same problems on my site

 

theres a tutorial on this site which is pretty good but i found it a little confusing being new to php as i am

 

but i found a very straight foward one right here

 

http://php.about.com/od/phpwithmysql/ss/php_pagination.htm

 

good luck