next and previous buttons for images from a MySQL database

[rupertbj]

How do I create a next and previous button for images and related variables from a database?
Any clues as to what I should be using greatly appreciated.

Code for buttons and variables set below:

<?php
include("header.inc");
?>
<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="80%" 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%" valign="middle" class="subtitle">previous</td>
    <td width="80%"><table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
        <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>
      </table></td>
    <td width="10%" valign="middle" class="subtitle"><div align="center">next</div></td>
  </tr>
</table>
<p>&nbsp;</p>
<?php		
include("footer.inc");		
?>

[batman]

Take this and work with it:

// limit value for number of records to be shown per page 
// query database to find total number of records to display 
$limit = 5; 
$query_count = "select * from ".$prefix."store_inventory where (description like '%$search%' or title like '%$search%')"; 
$result_count = mysql_query($query_count); 
$totalrows = mysql_num_rows($result_count); 
if(empty($page)) 
$page = 1; 
$limitvalue = $page * $limit - ($limit); 
$query = "select * from ".$prefix."store_inventory where (description like '%$search%' or title like '%$search%') LIMIT $limitvalue, $limit "; 
$result = mysql_query($query) or die("Error: " . mysql_error()); 
$count_result = mysql_num_rows($result); 

// Display links at the top to indicate current page and number of pages displayed
$numofpages = ceil($totalrows / $limit);
echo"<br><p><b>$totalrows</b> result(s) for: \"$search\"</p>";
$from=$limit*$page-$limit+1;
$to=$from + $count_result-1;

// start 123 next>> table
echo "<table align=\"center\" width=\"90%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
            <tr><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"left\">";if($numofpages>1){echo"Showing: $from - $to</td><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"right\"><b>Go to page:</b> ";} 

// display previous link if page is not 1
if($page != 1){ 
$pageprev = $page - 1; 
echo("<a href=\"$PHP_SELF?page=$pageprev&search=$search\"><< PREV</a>&nbsp;"); 
} 

// display page nos if not 1 
for($i = 1; $i <= $numofpages; $i++){ 
if($numofpages>1){
if($i == $page) 
echo("&nbsp;".$i."&nbsp;"); 
else
echo("&nbsp;<a href=\"$PHP_SELF?page=$i&search=$search\">$i</a>&nbsp;"); 
}}

// display next page link if there is more than one
if(($totalrows - ($limit * $page)) > 0){ 
$pagenext = $page + 1; 
echo("<a href=\"$PHP_SELF?page=$pagenext&search=$search\">NEXT >></a>"); 
}
// end 123 next>> table
echo"</td></tr></table><br>";

-Blake