Next / Previous for a DB driven site w/ pics

[rupertbj]

How do I make my script below work?
It works, but for 1 time only - I need it to go through all the paintings whichever direction (next or previous) and whenever either button is pressed.

Please help me spot where I have gone wrong.

You can see the script in action at http://www.octavianart.com/gallery.php?page=london

Thanks in advance for your help!

          <?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>
		  ";
		  break;
		  }
		  ?>

[PyroX]

Did you read this?
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10235043

Same concept described there.

[rupertbj]

I've read it and still have a few problems

new script:

<?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 LIMIT '$id', '$numrows'";
	$result = mysql_query( $sql, $link );
?>
<p>&nbsp;</p><?php print "$id and $numrows"; ?>
<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%" valign="top">Tour:</td>
          <td width="50%"><?php print " $page "; ?></td>
        </tr>
        <tr> 
          <td width="50%" valign="top">Name:</td>
          <td width="50%"><?php print " $name "; ?></td>
        </tr>
        <tr> 
          <td width="50%" valign="top">Materials:</td>
          <td width="50%"><?php print " $materials "; ?></td>
        </tr>
        <tr> 
          <td width="50%" valign="top">Size:</td>
          <td width="50%"><?php $size = stripslashes($size); print " $size "; ?></td>
        </tr>
        <tr> 
          <td width="50%" valign="top">Status:</td>
          <td width="50%"><?php print " $status "; ?></td>
        </tr>
        <tr> 
          <td width="50%" align="center" class="subtitle"> 
          <?php
		  $previd = $id--;
  		  $nextid = $id++;
		  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'];
		  print "
		  <a href=\"$PHP_SELF?id=$id&numrows=$numrows&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?id=$id&numrows=$numrows&nextid=$nextid&fupload=$fupload&name=$name&materials=$materials&status=$status&size=$size&page=$page\">next</a>
		  ";
		  break;
		  }
		  ?>
          </td>
        </tr>
      </table></td>
    <td width="10%">&nbsp;</td>
  </tr>
</table>
<p>&nbsp;</p>
<?php
mysql_close( $link );	
include("footer.inc");		
?>

Trouble is that id returns the field in the database which is an auto_increment value for each new database entry, and numrows returns the number of rows selected.

Is there a way to assign each selected entry with a new id newid so that i can go through them?

[batman]

LOL, this is probably the most commen subject on this board. 🙂

You might be able to use something like this to give each thing a value.

foreach($newArray as $newid)

-Blake

[rupertbj]

Ok - I'm getting there, but just need to make only 1 set of next and previous appear!

I tried break, but that doesn't seem to do the trick! see http://www.octavianart.com/display.php?id=45-&fupload=polzeath.jpg&name=Polzeath,%20Cornwall,%20England&materials=Oil%20on%20Board&status=Available&size=10"%20x%2012"&page=cornwall

new code as follows:

<?php
include("header.inc");
	$db = "gallery";
	$link = mysql_connect( "localhost:/users/georgel/domains/octavianart.com/sql/mysql.sock", "root" );
	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%" valign="top">Tour:</td>
          <td width="50%"><?php print " $page "; ?></td>
        </tr>
        <tr> 
          <td width="50%" valign="top">Name:</td>
          <td width="50%"><?php print " $name "; ?></td>
        </tr>
        <tr> 
          <td width="50%" valign="top">Materials:</td>
          <td width="50%"><?php print " $materials "; ?></td>
        </tr>
        <tr> 
          <td width="50%" valign="top">Size:</td>
          <td width="50%"><?php $size = stripslashes($size); print " $size "; ?></td>
        </tr>
        <tr> 
          <td width="50%" valign="top">Status:</td>
          <td width="50%"><?php print " $status "; ?></td>
        </tr>
        <tr> 
          <td width="50%" align="center" class="subtitle"> 
          <?php
		  $id = $newid;
		  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'];
		  print "
		  <a href=\"display.php?id=$newid-&fupload=$fupload&name=$name&materials=$materials&status=$status&size=$size&page=$page\">previous</a>
          </td>
          <td width=\"50%\" align=center class=subtitle> 
		  <a href=\"display.php?id=$id+&fupload=$fupload&name=$name&materials=$materials&status=$status&size=$size&page=$page\">next</a>
		  ";
		  foreach($newArray as $newid)
		  break;
		  }
		  ?>
          </td>
        </tr>
      </table></td>
    <td width="10%">&nbsp;</td>
  </tr>
</table>
<p>&nbsp;</p>
<?php
mysql_close( $link );	
include("footer.inc");		
?>

[batman]

What do you mean? It looks fine to me.