PHP - Pagination Navigation Not Showing.

I need a little help trying to figure this out.

I have a page that pulls up data, you can then click on one and go to a page with more detail. On this page you can use the PRrev & Next to go view another detail page on other data. My problem is if my 1st page has 6 sets of data on it but has a total of, say 50, you can only use the Prev & Next to view the 6. I want to be able to use the Prev & Next to go thru all 50.

ie
Page1 pulls this info
data1 data2 data3 data4 data5 data6 < << 1 2 [3] 4 5 6 > >> 


Page2

Data 1
Lots of info about data 1

< Prev  Next >

You will only be able to view the 6 data sets in the table above, however there are 50 I want to be able to use
the < Prev  Next > to go to all of them


Can someone help me with this?

here is my code
Page1
<?php
  session_start();

  // session timing
  // set timeout period in seconds
  $inactive = 120;

  // check to see if $_SESSION['timeout'] is set
    if(isset($_SESSION['timeout']) ) {
      $session_life = time() - $_SESSION['timeout'];
        if($session_life > $inactive)  {
          session_destroy(); }
    }

    $_SESSION['timeout'] = time();

  // END session timing

  include('library/login.php');
  login();
  mysql_select_db('test');
   

  // sets the sessions for all values
  $_SESSION=array_merge($_SESSION,$_POST);
  
    // echoing to verify
  $gender=$_SESSION[gender];
  $genderPref=$_SESSION[genderPref];
    echo "Chossen Gender".$_SESSION['gender'];
    echo "<br><Br>";
    echo "GenderPref".$_SESSION['genderPref'];
    echo "<br><Br>";
    
    

  // if the user has been timed out or not logged in
  if (!isset($_SESSION['clientID'])){
    echo "You are not a register user - set this to a simple search form";
    echo "<br><a href='form.php'>Form</a>";
  }

  // user is logged in
  else {
    $clientID = $_SESSION['clientID'];

    $sql="SELECT * FROM user WHERE userID='$clientID'";
    $result=mysql_query($sql);

    while ($r=mysql_fetch_array($result)) {
      $exp_date=$r["exp_date"];
      $todays_date=date("Y-m-d");
    }

  // verifies billing
  if ($exp_date >= $todays_date) {

    // billing is up to date
    $result = mysql_query("SELECT * FROM user WHERE gender='$gender'") or die(mysql_error());

// ------ Sets the display of data ------
      $num_rows = mysql_num_rows($result);

      // number of rows to show per page
      $rowsperpage = 8;

      // find out total pages
      $totalpages = ceil($num_rows / $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;



  $result = mysql_query("SELECT * FROM user WHERE gender='$gender' LIMIT $offset, $rowsperpage")or  die(mysql_error());
    $num_rows = mysql_num_rows($result);
    if ($num_rows == 0){
      echo "<div id='noResults'><span class='sorry'>Sorry</span>, no results found. <br> Please try again with broader search options.</div>"; }
    else {
      // format for search results
      $cells_wide = 2;
      echo " <table cellspacing='0' cellpadding='3' border='0' width='700'><tr> ";
      $c = 0;

      while ($r=mysql_fetch_array($result)) {
        $userID=$r["userID"];
        $gender=$r["gender"];
        $aUserIDs[] = $userID;

          if (0 < $c && 0 == $c % $cells_wide){
            echo " </tr><tr> "; }
            echo " <td width=175> ";
            echo "<a href='profileSession.php?userID=$r[userID]'>$userID</a>, $gender</td>";
            $c++;
          } // end of while
          echo " </tr>";
          echo " </table> ";
    }
// -------- BUILD THE PAGINATION LINKS --------------------------------

    $_SESSION['userID']=$aUserIDs;
    $_SESSION['userID2']=$aUserIDs2;
    echo "<div id='navigation'>";

    // range of num links to show
    $range = 3;

    // if not on page 1, show back links
    if ($currentpage > 1) {
      // show << link to go back to page 1
      echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1&gender=$genderPref&genderPref=$gender&ageMin=$ageMin&ageMax=$ageMax&year1=$year1&year2=$year2'>&lsaquo;&lsaquo; </a> ";

      // get previous page num
      $prevpage = $currentpage - 1;

      // show < link to go back to 1 page
      echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage&gender=$genderPref&genderPref=$gender&ageMin=$ageMin&ageMax=$ageMax&year1=$year1&year2=$year2'> &lsaquo; </a> ";
    } // END if ($currentpage > 1)

    // 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 ($totalpages == 1) {
          echo "";  }
        else{
          if ($x == $currentpage) {
            // 'highlight' it but don't make a link
            echo " [<b>$x</b>] ";
            // if not current page...
          } // END if ($x == $currentpage)
          else {
            // make it a link
            echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x&gender=$genderPref&genderPref=$gender&ageMin=$ageMin&ageMax=$ageMax&year1=$year1&year2=$year2'>$x</a> ";
          } // END else
        } // END else
      } // END if (($x > 0) && ($x <= $totalpages))
    } // END for loop

    // if not on last page, show forward and last page links
    if ($totalpages == 0) {
      echo "";  }
    else{
      if ($currentpage != $totalpages) {
        // get next page
        $nextpage = $currentpage + 1;

        // echo forward link for next page
        echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage&gender=$genderPref&genderPref=$gender&ageMin=$ageMin&ageMax=$ageMax&year1=$year1&year2=$year2'> &rsaquo; </a> ";

        // echo forward link for lastpage
        echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages&gender=$genderPref&genderPref=$gender&ageMin=$ageMin&ageMax=$ageMax&year1=$year1&year2=$year2'>&rsaquo;&rsaquo; </a> ";
      } // END if ($currentpage != $totalpages)
    }// END else
echo "<br>currentpage=$currentpage&gender=$genderPref&genderPref=$gender&ageMin=$ageMin&ageMax=$ageMax&year1=$year1&year2=$year2";

$link='currentpage=';
$link1='&gender=';
$link2='&genderPref=';
$link3='&ageMin=';
$link4='&ageMax=';
$link5='&year1=';
$link6='&year2=';
$total=$link.$currentpage.$link1.$genderPref.$link2.$gender.$link3.$ageMin.$link4.$ageMax.$link5.$year1.$link6.$year2;
$_SESSION['pages']=$total;
echo "<br>$total";

// -------- END PAGINATION --------------------------------------------
    
  } // END if ($exp_date >= $todays_date)
  else  {
    // billing has expired
    echo "Billing has expired<br>";
    echo $_SESSION['clientID'];

    echo "<br><a href='session2.php'>Sesssion2</a>";
    echo "<br><a href='form.php'>Form</a>";
  }


  } // END valid session

?>


Page2
<?php
  session_start(); // start up your PHP session!

  include('library/login.php');
  login();
  mysql_select_db('test');

  $userID=$_GET["userID"];
  $link=$_SESSION['pages'];

  // Sends back to display page
  echo "<a href='searchSession.php?$link' title='Back to Search'>Back to Search</a>&nbsp;";

  // sets the Prev & Next
  $aUsers = isset($_SESSION['userID']) ? $_SESSION['userID'] : array();

  $current = $userID; // Ok our current.
  $iCurKey = array_search($current, $aUsers);

  $prev = null;
  $next = null;

  if ($iCurKey !== false){
    $prev = $iCurKey >= 1 ? $aUsers[$iCurKey - 1] : null;
    $next = $iCurKey < count($aUsers) - 1 ? $aUsers[$iCurKey + 1] : null;
  }

  // Lets do this simple.
  if ($prev !== null){
    echo '&nbsp;<A href="?userID=' . $prev . '">&laquo; Previous</A>&nbsp;&nbsp;';
  }
  else{
    echo "&nbsp;<span class='empty'>&laquo; Previous</span>&nbsp;&nbsp;";
  }

  if ($next !== null){
    echo '<A class=right href="?userID=' . $next . '">Next &raquo;</A>&nbsp;';
  }
  else{
    echo "<span class='empty'>&nbsp;Next &raquo;</span>";
  }
  // END of the Prev & Next

  $result = mysql_query("SELECT userID, first_name, gender
    FROM user
    WHERE userID='$userID'") or die(mysql_error());

  while ($r=mysql_fetch_array($result)){
    $userID=$r["userID"];
    $first_name=$r["first_name"];
    $gender=$r["gender"];
  }

  echo "<br>$userID, $first_name, $gender";

?>

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 ive simple code. but i would need help how to do pagination. ive followed one tutorial and ive code.but i really dont know how to connect these.or if its even possible to connect.

heres the index.php file

Code: [Select]
<?php

include '_class/cms_class.php';

$obj = new modernCMS();

$obj->host =  'localhost';
$obj->username =  'root';
$obj->password =  'root';
$obj->db =  'modernCMS';

$obj->connect();

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
<link rel="stylesheet" href="style.css" type="text/css" media="screen" title="no title" charset="utf-8">

</head>

<body>

<div id="page-wrap">
<?php 

if(isset($_GET['id'])):
$obj->get_content($_GET['id']);
else:
$obj->get_content();
endif;

?>
</div>
</body>
</html>
cms_class.php
Code: [Select]
<?php 

class modernCMS {

var $host;
var $username;
var $password;
var $db;

function connect() {
$con = mysql_connect($this->host, $this->username, $this->password) or die(mysql_error());
mysql_select_db($this->db, $con) or die(mysql_error());
}



function get_content($id = '') {

if($id != ""):
$id = mysql_real_escape_string($id);
$sql = "SELECT * FROM cms_content WHERE id = '$id'";

else:
$sql = "SELECT * FROM cms_content ORDER BY id DESC";
endif;

$res = mysql_query($sql) or die(mysql_error());

while($row = mysql_fetch_assoc($res)) {
echo '<h1><a href="index.php?id=' . $row['id'] . '">' . $row['title'] . '</a></h1>';
echo '<p>' . $row['body'] . '</p>';
}


}



} 

?>
Heres the pagination code ihave
Code: [Select]
<?php

include 'db.inc.php';
$per_page = 2;



$pages_query = mysql_query("SELECT COUNT(`id`) FROM `cms_content`");
$pages = ceil(mysql_result($pages_query, 0) / $per_page);

$page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
$start = ($page - 1) * $per_page;

$query = mysql_query("SELECT * FROM `cms_content` LIMIT $start, $per_page");
while ($query_row = mysql_fetch_assoc($query)) {

echo '<p>', $query_row['title']   ,'</p>';
echo '<p>', $query_row['body']   ,'</p>';


}

if ($pages >=1 && $page <= $pages) {

for ($x=1; $x<=$pages; $x++) {
echo ($x == $page) ? '<strong><a href="?page=' .$x. '">' .$x. '</a></strong>  ' : '<a href="?page=' .$x. '">' .$x. '</a> ';


}


}

?>
thanks.

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); 

Hi guys,

I have a question about pagination. It's not really about the coding side so I'm really sorry if this is the wrong section!

Ok my question is, does pagination actually create multiple pages? I'm really new to PHP and I'm just reading through different things and tutorials to try and figure it out if you will.


So does it create new pages? From my understanding it simply changes a variable to a page number and uses that page number (and simple matH) to figure out what rows to show. If this is the case, how do people use pagination to create links such as http://example.com/imnooby/page-1
http://example.com/imnooby/page-2
http://example.com/imnooby/page-3

Surely if this was all just one page, it would just be http://example.com/imnooby/page and the variable would change depending on the button, but the same page would be reloaded?

This is the part that's really bugging me and any explanation would really help.

Sorry to bug yalls with yet another problem, but I tried applying pagination to the page I use to display the news on my website, which is stored within mysql, and I'm having major issues. Here's the code below for both the pagination and getting the news out of the database to display. Not sure what's going on here. I tested the script and it does everything fine except it doesn't display the information stored within the database.

Go here to see for yourself:
http://www.djsmiley.net/index.php

Code: [Select]
<?php
/*
Place code to connect to your DB here.
*/
include('cms/news/dbconnect.php'); // include your code to connect to DB.

$tbl_name="mynews"; //your table name
// How many adjacent pages should be shown on each side?
$adjacents = 3;

/* 
   First get total number of rows in data table. 
   If you have a WHERE clause in your query, make sure you mirror it here.
*/
$query = "SELECT COUNT(*) as num FROM $tbl_name";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

/* Setup vars for query. */
$targetpage = "index.php";  //your file name  (the name of this file)
$limit = 1;  //how many items to show per page
$page = $_GET['page'];
if($page) 
$start = ($page - 1) * $limit;  //first item to display on this page
else
$start = 0; //if no page var is given, set start to 0

/* Get data. */
$sql = "SELECT 10 FROM $tbl_name LIMIT $start, $limit";
$result = mysql_query($sql);

/* Setup page vars for display. */
if ($page == 0) $page = 1; //if no page var is given, default to 1.
$prev = $page - 1; //previous page is page - 1
$next = $page + 1; //next page is page + 1
$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1; //last page minus 1

/* 
Now we apply our rules and draw the pagination object. 
We're actually saving the code to a variable in case we want to draw it more than once.
*/
$pagination = "";
if($lastpage > 1)
{
$pagination .= "<div class=\"pagination\">";
//previous button
if ($page > 1) 
$pagination.= "<a href=\"$targetpage?page=$prev\"><img class=\"fltlft2\" src=\"http://www.djsmiley.net/images/Icons/Arrows/Previous.png\" height=\"25\" width=\"25\"></a>";
else
$pagination.= "<span class=\"disabled\"><img class=\"fltlft2\" src=\"http://www.djsmiley.net/images/Icons/Arrows/Previous.png\" height=\"25\" width=\"25\"></a></span>";

//pages
if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
}
elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
{
//close to beginning; only hide later pages
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
}
//in middle; hide some front and some back
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
$pagination.= "...";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
}
//close to end; only hide early pages
else
{
$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
$pagination.= "...";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
}
}

//next button
if ($page < $counter - 1) 
$pagination.= "<a href=\"$targetpage?page=$next\"><img src=\"http://www.djsmiley.net/images/Icons/Arrows/Next.png\" height=\"25\" width=\"25\"></a>";
else
$pagination.= "<span class=\"disabled\"><img src=\"http://www.djsmiley.net/images/Icons/Arrows/Next.png\" height=\"25\" width=\"25\"></span>";
$pagination.= "</div>\n";
}
?>

<?php
while($row = mysql_fetch_array($result))
{
echo("<p class=NewsContainer><span class=NewsID>$type</span> <font size=5>$title</font><br><br>
<em>posted by <strong>$user</strong> | added on $time</em><br><br> 
$message<br><br>
<label class=fltlft2><img src=../images/Icons/Arrows/Right.png width=20 height=20/></label><a href=$url>Read more - $url</a>
<div class=newsLikeShareRate>
  <table width=100% border=0>
<tr>
  <td width=3% height=21><script src=http://connect.facebook.net/en_US/all.js#xfbml=1></script>
  <fb:like href='$url' show_faces=true width=450 font=arial></fb:like>
                              </td>
<td width=65%><a name=fb_share id=fb_share4 type=icon_link 
   share_url=$url>Share</a>
  <script src=http://static.ak.fbcdn.net/connect.php/js/FB.Share 
type=text/javascript></script></td>
  <td width=32%>Rate this article:
   </td>
</tr>
  </table>
</div></p><br><br>");// Your while loop here

}
?>

<?=$pagination?>

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.

Hi every one

im getting an error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
SELECT * FROM

Code: [Select]
if(isset($_GET['subid'])){
                      $id = $_GET['subid'];
}
                     $query = mysql_query("SELECT * FROM sub_nav WHERE subNav_ID=" . mysql_real_escape_string((int)$id));
$row = mysql_fetch_assoc($query);
$table =  strtolower($row['subNavName']);
// ******************************* This if statment controls the content ************************
if($row['show_hide'] == 1){
                      $per_page = 2;

$pages_query = mysql_query("SELECT COUNT('id') FROM textiles");

$pages = ceil(mysql_result($pages_query, 0) / $per_page);

$page = (isset($_GET['p']) AND (int)$_GET['p'] > 0) ? (int)$_GET['p'] : 1;
 
$start = ($page-1) * $per_page;

$query = mysql_query("SELECT imageName FROM textiles LIMIT $start, $per_page");





while ($query_row = mysql_fetch_assoc($query)){
echo '<p>',$query_row['imageName'] , '</p>';
}


if ($pages >= 1){

for($x=1; $x<=$pages; $x++){
echo '<a href="?p='.$x.'">'.$x.'</a> ';
}
}

Can any one help please

Hello! I have a database of small image / names that I want to pull into a 3 x 4 table. My current code works perfectly if I have 12 images or less, but I will have more than 12 images. Currently the code is set up to retrieve and display the images in a table, three per table row. I want it so that when it reaches the 4th row in a page it generates a link to another page that has the next 3 x 4 (12 total images) page.  I tried to follow the code on http://www.phpfreaks.com/tutorial/basic-pagination, but after I get it to what I think it should be, my page is blank -- but not due to an error, it's just blank. My code so far is:

<?php


$username = "xxxx";
$password = "xxxxx";
$host = "localhost";
$database = "images";
$conn = mysql_connect($host, $username, $password) or die("Can not connect to database: ".mysql_error());

$db = mysql_select_db($database) or die("Can not select the database: ".mysql_error());

$sql = "SELECT * FROM block_work ORDER BY Name";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

header('Content-type: image/jpg');
$counter = 0;
while ($row = mysql_fetch_array($result)) {
if($counter==0) print "<tr align='center'>";
++$counter;


print "<td align='center' width='179' height='200'><img src='/management/show.php?id=" . $row['id'] . "&table=block_work' alt='" . $row['name'] . "' /><br/>";
print "<b>" . $row['name'] . "</b></td>";


if($counter==3) {
$counter=0;
print "</tr>";
};
};
while ($counter>0) {
++$counter;
print " <td>&nbsp;</td>";
if($counter==3) {
$counter=0;
print "</tr>";
}
}
print "</table>";

mysql_close($con);


?>
Thanks very much for any help!

-Gerry

Code: [Select]
<?php
$title="Search";
$metakeywords="search, find";
$metadescription="Search for your love!";
include ('header.php');

$getpage=clean_up($_GET['page']);
$getpage = abs((int) ($getpage));


echo '
<table width="100%"><tr><td valign="top" class="content">
            <form action="index.php?action=search" method="post">

                  <b>Seeking Gender</b>
                  <select name="gender">
                    <option value="">Either</option>
                    <option value="Male">Male</option>
                    <option value="Female">Female</option>
                  </select>
<hr>
                  <b>Smoke?</b>
                  <select name="smoke">
                    <option value="">Doesn\'t matter</option>
                    <option value="Yes">Yes</option>
                    <option value="No">No</option>
                  </select>
<hr>

                  <b>Drink?</b>
                  <select name="drink">
                    <option value="">Doesn\'t matter</option>
                    <option value="Yes">Yes</option>
                    <option value="No">No</option>
                  </select>


<hr>

                  <b>Body Type </b>
                  <select name="bodytype">
                    <option value="">Doesn\'t matter</option>
<option value="Slim / Slender">Slim / Slender</option>
<option value="Athletic">Athletic</option>
<option value="Average">Average</option>
<option value="Some extra baggage">Some extra baggage</option>
<option value="Body builder">Body builder</option>
                  </select>


</td><td valign="top" class="content">

                  <b>First Name</b>
<input type="text" name="first" size="17"><br> <b>Last Name</b><input type="text" name="last" size="17">

<hr>


<b>Sexual orientation</b>
               <select class="orientation" name="orientation">
               <option value="">Any</option>
<option value="Bi">Bi</option>
<option value="Gay/Lesbian">Gay/Lesbian</option>
<option value="Straight">Straight</option>
                  </select>

<hr>

                  <b>Age Range</b>
                  <select class="date" name="age_from">';


$years = range( 16, 100 );

foreach( $years as $v ) {
     echo "<option value=\"$v\">$v</option>\n";
}
echo '
                  </select>
 to 
                  <select class="date" name="age_to">';

$yyears = range( 17, 100 );

foreach( $yyears as $v ) {
     echo "<option value=\"$v\">$v</option>\n";
}
echo '</select>

</td><td valign="top" class="content">

<b>Religion</b>
               <select name="religious">
               <option value="">Any</option>
<option value="Agnostic">Agnostic</option>
<option value="Atheist">Atheist</option>
<option value="Buddhist">Buddhist</option>
<option value="Catholic">Catholic</option>
<option value="Christian">Christian</option>
<option value="Hindu">Hindu</option>
<option value="Jewish">Jewish</option>
<option value="Mormon">Mormon</option>
<option value="Muslim">Muslim</option>
<option value="Other">Other</option>
<option value="Protestant">Protestant</option>
<option value="Satanist">Satanist</option>
<option value="Scientologist">Scientologist</option>
<option value="Taoist">Taoist</option>
<option value="Wiccan">Wiccan</option>
                  </select>

<hr>



<b>Ethnicity</b>
               <select name="ethnicity">
               <option value="">Any</option>
<option value="Asian">Asian</option>
<option value="Black / African descent">Black / African descent</option>
<option value="East Indian">East Indian</option>
<option value="Latino / Hispanic">Latino / Hispanic</option>
<option value="Middle Eastern">Middle Eastern</option>
<option value="Native American">Native American</option>
<option value="Pacific Islander">Pacific Islander</option>
<option value="White / Caucasian">White / Caucasian</option>
<option value="Other">Other</option>
                  </select>

<hr>


<b>Children</b>
               <select name="children">
               <option value="">Doesn\'t matter</option>
<option value="I don\'t want kids">I don\'t want kids</option>
<option value="Love kids, but not for me">Love kids, but not for me</option>
<option value="Undecided">Undecided</option>
<option value="Someday">Someday</option>
<option value="Expecting">Expecting</option>
<option value="Proud parent">Proud parent</option>
                  </select>

<hr>


<b>Education</b>
               <select name="education">
               <option value="">Doesn\'t matter</option>
<option value="High school">High school</option>
<option value="Some college">Some college</option>
<option value="In college">In college</option>
<option value="College graduate">College graduate</option>
<option value="Grad / professional school">Grad / professional school</option>
<option value="Post grad">Post grad</option>
                  </select>

                  <br><input type="submit" name="submit" value="Search" /></form>
</td></tr></table>';

if($_POST['submit'] || $_GET['page'] > "0"){
$first = clean_up($_POST['first']);
$last = clean_up($_POST['last']);
$smoke = clean_up($_POST['smoke']);
$drink = clean_up($_POST['drink']);
$gender = clean_up($_POST['gender']);
$age_from = clean_up($_POST['age_from']);
$age_to = clean_up($_POST['age_to']);
$orientation = clean_up($_POST['orientation']);
$religious = clean_up($_POST['religious']);
$ethnicity = clean_up($_POST['ethnicity']);
$bodytype = clean_up($_POST['bodytype']);
$children = clean_up($_POST['children']);
$education = clean_up($_POST['education']);

if(!$_GET['page']){
if(!$first == ""){ setcookie("first", $first, time()+3600); }
if(!$last == ""){ setcookie("last", $last, time()+3600); }
if(!$smoke == ""){ setcookie("smoke", $smoke, time()+3600); }
if(!$drink == ""){ setcookie("drink", $drink, time()+3600); }
if(!$gender == ""){ setcookie("gender", $gender, time()+3600); }
if(!$age_from == ""){ setcookie("age_from", "$age_from", time()+3600); }
if(!$age_to == ""){ setcookie("age_to", "$age_to", time()+3600); }
if(!$orientation == ""){ setcookie("orientation", $orientation, time()+3600); }
if(!$religious == ""){ setcookie("religious", $religious, time()+3600); }
if(!$ethnicity == ""){ setcookie("ethnicity", $ethnicity, time()+3600); }
if(!$bodytype == ""){ setcookie("bodytype", $bodytype, time()+3600); }
if(!$children == ""){ setcookie("children", $children, time()+3600); }
if(!$education == ""){ setcookie("education", $education, time()+3600); }
}



$qquery = "SELECT `id`, `first`, `last`, `avatar`, `gender`, `about`, 
( (DATE_FORMAT(CURDATE(),'%Y') - DATE_FORMAT(`bdate`, '%Y') ) - ( DATE_FORMAT(CURDATE(), '00-%m-%d') < DATE_FORMAT( `bdate`, '00-%m-%d')) ) AS age
FROM `users`
WHERE ( (DATE_FORMAT(CURDATE(),'%Y') - DATE_FORMAT(`bdate`, '%Y') ) - ( DATE_FORMAT(CURDATE(), '00-%m-%d') < DATE_FORMAT( `bdate`, '00-%m-%d')) ) BETWEEN $age_from AND $age_to";

// if any of the options that are stored in the `users` table are selected, add AND to the query string,
//and store each needed part in an array, $users_criteria
if( $gender != "" || $first != "" || $last != "" ) {
$qquery .= ' AND ';
$users_criteria = array();
if( !empty($gender) ) {
$users_criteria[] = "`gender` = '$gender'";
}
if( !empty($first) ) {
$users_criteria[] = "`first` LIKE '%$first%'";
}
if( !empty($last) ) {
$users_criteria[] = "`last` LIKE '%$last%'";
}
$qquery .= implode( ' AND ', $users_criteria ); // implode the array, separating each part with AND, and append to query string
}

// Same process as above, but for results that come from `questions` table
if( $smoke != '' || $drink != '' || $orientation != '' || $religious != '' || $ethnicity != '' || $bodytype != '' ) {
$qquery .= ' AND id IN( SELECT `userid` FROM `questions` WHERE ';
$questions_criteria = array();
if( !empty($smoke) ) {
$questions_criteria[] = "`smoke` = '$smoke'";
}
if( !empty($drink) ) {
$questions_criteria[] = "`drink` = '$drink'";
}
if( !empty($orientation) ) {
$questions_criteria[] = "`orientation` = '$orientation'";
}
if( !empty($religious) ) {
$questions_criteria[] = "`religious` = '$religious'";
}
if( !empty($ethnicity) ) {
$questions_criteria[] = "`ethnicity` = '$ethnicity'";
}
if( !empty($bodytype) ) {
$questions_criteria[] = "`body_type` = '$bodytype'";
}
if( !empty($children) ) {
$questions_criteria[] = "`children` = '$children'";
}
if( !empty($education) ) {
$questions_criteria[] = "`education` = '$education'";
}
$qquery .= implode( ' AND ', $questions_criteria );
$qquery .= ' )';
}
$total = mysql_num_rows(mysql_query($qquery));

$page_count = ceil($total / 2);

$page = 1;
if (isset($getpage) && $getpage >= 1 && $getpage <= $page_count) {
    $page = (int)$getpage;
}
$skip = ($page - 1) * 2;

$query = "SELECT `id`, `first`, `last`, `avatar`, `gender`, `about`, 
( (DATE_FORMAT(CURDATE(),'%Y') - DATE_FORMAT(`bdate`, '%Y') ) - ( DATE_FORMAT(CURDATE(), '00-%m-%d') < DATE_FORMAT( `bdate`, '00-%m-%d')) ) AS age
FROM `users`
WHERE ( (DATE_FORMAT(CURDATE(),'%Y') - DATE_FORMAT(`bdate`, '%Y') ) - ( DATE_FORMAT(CURDATE(), '00-%m-%d') < DATE_FORMAT( `bdate`, '00-%m-%d')) ) BETWEEN $age_from AND $age_to";

// if any of the options that are stored in the `users` table are selected, add AND to the query string,
//and store each needed part in an array, $users_criteria
if( $gender != "" || $first != "" || $last != "" ) {
$query .= ' AND ';
$users_criteria = array();
if( !empty($gender) ) {
$users_criteria[] = "`gender` = '$gender'";
}
if( !empty($first) ) {
$users_criteria[] = "`first` LIKE '%$first%'";
}
if( !empty($last) ) {
$users_criteria[] = "`last` LIKE '%$last%'";
}
$query .= implode( ' AND ', $users_criteria ); // implode the array, separating each part with AND, and append to query string
}

// Same process as above, but for results that come from `questions` table
if( $smoke != '' || $drink != '' || $orientation != '' || $religious != '' || $ethnicity != '' || $bodytype != '' ) {
$query .= ' AND id IN( SELECT `userid` FROM `questions` WHERE ';
$questions_criteria = array();
if( !empty($smoke) ) {
$questions_criteria[] = "`smoke` = '$smoke'";
}
if( !empty($drink) ) {
$questions_criteria[] = "`drink` = '$drink'";
}
if( !empty($orientation) ) {
$questions_criteria[] = "`orientation` = '$orientation'";
}
if( !empty($religious) ) {
$questions_criteria[] = "`religious` = '$religious'";
}
if( !empty($ethnicity) ) {
$questions_criteria[] = "`ethnicity` = '$ethnicity'";
}
if( !empty($bodytype) ) {
$questions_criteria[] = "`body_type` = '$bodytype'";
}
if( !empty($children) ) {
$questions_criteria[] = "`children` = '$children'";
}
if( !empty($education) ) {
$questions_criteria[] = "`education` = '$education'";
}
$query .= implode( ' AND ', $questions_criteria );
$query .= ' LIMIT $skip, 2 )';
}


echo "<table width='100%' align='center'>";

if( $result = mysql_query( $query ) ) {
if( mysql_num_rows($result) > 0 ) {
while( $rr3 = mysql_fetch_assoc($result) ) {
$user=clean_up($rr3[id]);
$first=clean_up($rr3[first]);
$last=clean_up($rr3[last]);
$avatar=clean_up($rr3['avatar']);
$about=clean_up($rr3[about]);

echo "<tr><td valign='top' width='140' class='content'><center><img src='avatars/thumb/$avatar' /><br><a href='index.php?action=profile&id=$user'> $first $last</a></center></td><td class='content' valign='top'>".limitdesc($about)."</td></tr>";
}
} else {
echo '<tr><td colspan="2">Sorry, your search returned no results.</td></tr>';
}
} else {
echo '<tr><td colspan="2">We\'re sorry, there has been an error processing your request. Please try later.</td></tr>';
}
echo "</table>";


echo "<div class='content'><center>";

if($getpage == 0 || $getpage == 1){}else{
  $plink = $getpage - 1;
  echo "&nbsp; &nbsp; &nbsp; <a href='index.php?action=search&page=$plink'>Previous</a> &nbsp; &nbsp; &nbsp; ";
}

echo "<select id='ddp' onchange='document.location=(ddp.value)'>
<option value=''>Page #</option>";
for ($i = 1; $i <= $page_count; ++$i){
    echo ' <option value="index.php?action=search&page=' . $i . '">' . $i . '</option>';
} 
echo "</select>";

if($getpage == $page_count){}else{
if($page_count>1){
if($getpage == 0){
  echo " &nbsp; &nbsp; &nbsp; <a href='index.php?action=search&page=2'>Next</a> &nbsp; &nbsp; &nbsp; ";
}else{
  $nlink = $getpage + 1;
  echo " &nbsp; &nbsp; &nbsp; <a href='index.php?action=search&page=$nlink'>Next</a> &nbsp; &nbsp; &nbsp; ";
}
}
}
echo "</center></div>";

}

include ('footer.php'); ?>

I keep getting these errors:
Code: [Select]
Warning: Cannot modify header information - headers already sent by (output started at /home/gamersgo/public_html/datingsnap.com/header.php:4) in /home/gamersgo/public_html/datingsnap.com/pages/search.php on line 182

Warning: Cannot modify header information - headers already sent by (output started at /home/gamersgo/public_html/datingsnap.com/header.php:4) in /home/gamersgo/public_html/datingsnap.com/pages/search.php on line 183

the errors are coming from the setcookie lines. any idea why its spitting out that?

and when I search, the results don't come out to two results per page. so the pagination isn't working right and i am getting those errors. any ideas?

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. 

Using the tutorial from php freaks i was able to get pagination working on my site. How ever there are a few changes id like to make. I would like to have it listed in 2 columns. The other problem that I'm having is when i attempt to add class="nav" to the next page link i get an error. Can a class be used in a php echo?

Here's what I have.

Code: [Select]
<?php  session_start(); 
$rank=$_SESSION['rank'];
$loggedinusername=$_SESSION['loggedinusername'];
$loggedinuseremail=$_SESSION['loggedinuseremail'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Drink To The Credits</title>
<link href="mainstyle.css" rel="stylesheet" type="text/css" />
</head>

<body class="background">
<div id="header"> <?php include_once"header.php" ?></div>

<div id="content">   

<?php

include"scripts/connect.php" ;

mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or trigger_error("SQL", E_USER_ERROR);

$sql = "SELECT COUNT(*) FROM movies WHERE type LIKE 'movie'";
$result = mysql_query($sql) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];
$rowsperpage = 15;
$totalpages = ceil($numrows / $rowsperpage);


if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
   $currentpage = (int) $_GET['currentpage'];
} else {
   $currentpage = 1;
}
if ($currentpage > $totalpages) {
   $currentpage = $totalpages;
} 
if ($currentpage < 1) {
   $currentpage = 1;
} 

$offset = ($currentpage - 1) * $rowsperpage;
$sql = "SELECT title FROM movies ORDER BY title LIMIT $offset, $rowsperpage" ;
$result = mysql_query($sql) or trigger_error("SQL", E_USER_ERROR);

while ($list = mysql_fetch_assoc($result)) {
     ?>
<tr>
<td> <a class="nav" href=/rules.php?title=<?php echo urlencode($list['title']); ?>><?php echo $list['title']; ?></a> <br />
<?php
} 
$range = 3;

if ($currentpage > 1) {
   echo " <a href='<?php {$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";
   $prevpage = $currentpage - 1;
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
} 
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
   if (($x > 0) && ($x <= $totalpages)) {
      if ($x == $currentpage) {
         echo " [<b>$x</b>] ";
      } else {
         echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
      } 
   } 
} 
        
if ($currentpage != $totalpages) {
   $nextpage = $currentpage + 1;
    
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";
} // built with a tutorial from php freaks
?>
</div>

<div id="sidecontent"><?php include_once"newmovies.php" ?></div>
<div id="footer"> <?php include_once"footer.php" ?></div>
</body>
</html>

Thank you in advance