Nearly there - next + prev buttons - but one little problem

rupertbj

I am designing a webpage for a artist client and need to be able to go through images within a particular gallery with prev and next buttons. please see http://www.octavianart.com/gallery.php?page=croatia and press on one of the paintings and you will see the problem!

Code below:

<?php
include("header.inc");
	$db = "gallery";
	$link = mysql_connect( "user", "pass" );
	if ( !$link ) die( "Couldn't connect to MySQL" );
	mysql_select_db( $db, $link ) or die( "Couldn't open $db: ".mysql_error() );
	$sql = "SELECT * FROM galleryTable Where tour = '$page' ORDER BY id DESC";
	$result = mysql_query( $sql, $link );
?>
<p>&nbsp;</p>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="10%" valign="middle" class="subtitle"><div align="center"></div></td>
    <td width="120%" align=center><?php print "<img src=\"/images/archive/$fupload\"> "; ?></td>
    <td width="10%" valign="middle" class="subtitle"><div align="center"></div></td>
  </tr>
  <tr> 
    <td width="10%">&nbsp;</td>
    <td width="80%"><table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td width="50%">Tour:</td>
          <td width="50%"><?php print " $page "; ?></td>
        </tr>
        <tr> 
          <td width="50%">Name:</td>
          <td width="50%"><?php print " $name "; ?></td>
        </tr>
        <tr> 
          <td width="50%">Materials:</td>
          <td width="50%"><?php print " $materials "; ?></td>
        </tr>
        <tr> 
          <td width="50%">Size:</td>
          <td width="50%"><?php $size = stripslashes($size); print " $size "; ?></td>
        </tr>
        <tr> 
          <td width="50%">Status:</td>
          <td width="50%"><?php print " $status "; ?></td>
        </tr>
        <tr> 
          <td width="50%" align="center" class="subtitle"> 
          <?php
		  while ( $newArray = mysql_fetch_array($result) )
		  {
		  $id = $newArray['id'];
		  $status = $newArray['status'];
		  $name = $newArray['name'];
		  $materials = $newArray['materials'];
		  $size = $newArray['size'];
		  $size = htmlspecialchars($size);
		  $fupload = $newArray['fupload'];
		  $tupload = $newArray['tupload'];
		  $previd = $id--;
  		  $nextid = $id++;
		  print "
		  <a href=\"$PHP_SELF?previd=$previd&fupload=$fupload&name=$name&materials=$materials&status=$status&size=$size&page=$page\">previous</a>
          </td>
          <td width=\"50%\" align=center class=subtitle> 
		  <a href=\"$PHP_SELF?nextid=$nextid&fupload=$fupload&name=$name&materials=$materials&status=$status&size=$size&page=$page\">next</a>
		  ";
		  }
		  ?>
          </td>
        </tr>
      </table></td>
    <td width="10%">&nbsp;</td>
  </tr>
</table>
<p>&nbsp;</p>
<?php
mysql_close( $link );	
include("footer.inc");		
?>

The_Chancer

Why not use the LIMIT function in the MYSQL query to choose which painting you want ?

Then the previd and nextid variables would be useful....

Because you are taking everything out of the gallery table you are getting the next / previous buttons the same amount of times that there are pictures in the gallery.

If you look at the example code given by Batman in your previous post, you will see a second query.

The first one gives the number of rows (or pages if you are only displaying one to a page), the second one is the query that is used to display the picture.

The LIMIT function is your answer, all you have to do is work out the number to display and the offset needed...

http://www.mysql.com is a good place to start...

rupertbj

I don't understand how limit can work. The variables are spread throughout a table and not in any order.

Isn't there some way of breaking out of the while statement and using the variables set there?

The_Chancer

Becasue you are using the ORDER BY id, I was assuming that there is some continuity with your rows....

Even if the order is a little messed up, with non consecutive id numbers, ORDER BY will list them as:

1,5,7,9,11,16 etc

Not
1,7,5,9,16,11...

So because you have ordered the list, you can use LIMIT to start at the 1st record and only pick that record, then in the next link, tell it to only get the second record, and only that record..

E.g. LIMIT 0,1 - only the first record
LIMIT 1,1 - Only the second record
LIMIT 1,-1 From the second record until the end....
LIMIT 1,2 Records 2 and 3 only

So by using the number of the record you want - you can get to it by the LIMIT function....

Make it any clearer ?