Here is my code for the community:
<?php require_once('../Connections/conn_phototek.php'); ?>
<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$colname_rsThumb = "1";
if (isset($HTTP_GET_VARS['ImageID'])) {
$colname_rsThumb = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['ImageID'] : addslashes($HTTP_GET_VARS['ImageID']);
}
mysql_select_db($database_conn_phototek, $conn_phototek);
$query_rsThumb = sprintf("SELECT phototek.*, format.im_format, color.im_color, catgen.im_catgen, cat.im_cat, cont.im_cont, pays.im_pays, pays.flags, ville.im_ville FROM phototek, format, color, catgen, cat, cont, pays, ville WHERE format.formatID=phototek.formatID AND color.colorID=phototek.colorID AND catgen.catgenID=cat.catgenID AND cat.catID=phototek.catID AND cont.contID=pays.contID AND pays.paysID=ville.paysID AND ville.villeID=phototek.villeID AND phototek.ImageID=%s", $colname_rsThumb);
$rsThumb = mysql_query($query_rsThumb, $conn_phototek) or die(mysql_error());
$row_rsThumb = mysql_fetch_assoc($rsThumb);
$totalRows_rsThumb = mysql_num_rows($rsThumb);
$maxRows_rsNav = 1;
$pageNum_rsNav = '-1';
if (isset($HTTP_GET_VARS['pageNum_rsNav'])) {
$pageNum_rsNav = $HTTP_GET_VARS['pageNum_rsNav'];
}
$startRow_rsNav = $pageNum_rsNav * $maxRows_rsNav;
$colname_rsNav = "1";
if (isset($row_rsThumb['catID'])) {
$colname_rsNav = (get_magic_quotes_gpc()) ? $row_rsThumb['catID'] : addslashes($row_rsThumb['catID']);
}
mysql_select_db($database_conn_phototek, $conn_phototek);
$query_rsNav = sprintf("SELECT phototek.*, catgen.im_catgen, cat.im_cat FROM phototek, catgen, cat WHERE catgen.catgenID=cat.catgenID AND cat.catID=phototek.catID AND phototek.ImageID!=$colname_rsThumb AND cat.catID=%s", $colname_rsNav);
$query_limit_rsNav = sprintf("%s LIMIT %d, %d", $query_rsNav, $startRow_rsNav, $maxRows_rsNav);
$rsNav = mysql_query($query_limit_rsNav, $conn_phototek) or die(mysql_error());
$row_rsNav = mysql_fetch_assoc($rsNav);
if (isset($HTTP_GET_VARS['totalRows_rsNav'])) {
$totalRows_rsNav = $HTTP_GET_VARS['totalRows_rsNav'];
} else {
$all_rsNav = mysql_query($query_rsNav);
$totalRows_rsNav = mysql_num_rows($all_rsNav);
}
$totalPages_rsNav = ceil($totalRows_rsNav/$maxRows_rsNav)-1;
$queryString_rsNav = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_rsNav") == false &&
stristr($param, "totalRows_rsNav") == false &&
stristr($param, "totalRows_rsNav") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsNav = "&" . implode("&", $newParams);
}
}
$queryString_rsNav = sprintf("&totalRows_rsNav=%d%s", $totalRows_rsNav, $queryString_rsNav);
?>
<html>
<head>
<title>Document sans titre</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<p> </p>
<table border="0" width="50%" align="center">
<tr>
<td width="23%" align="center">
<?php if ($pageNum_rsNav > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsNav=%d%s", $currentPage, 0, $queryString_rsNav); ?>"><img src="First.gif" border=0></a>
<?php } // Show if not first page ?>
</td>
<td width="31%" align="center">
<?php if ($pageNum_rsNav > '-1') { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsNav=%d%s", $currentPage, max('-1', $pageNum_rsNav - 1), $queryString_rsNav); ?>"><img src="Previous.gif" border=0></a>
<?php } // Show if not first page ?>
</td>
<td width="23%" align="center">
<?php if ($pageNum_rsNav < $totalPages_rsNav) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsNav=%d%s", $currentPage, min($totalPages_rsNav, $pageNum_rsNav + 1), $queryString_rsNav); ?>"><img src="Next.gif" border=0></a>
<?php } // Show if not last page ?>
</td>
<td width="23%" align="center">
<?php if ($pageNum_rsNav < $totalPages_rsNav) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsNav=%d%s", $currentPage, $totalPages_rsNav, $queryString_rsNav); ?>"><img src="Last.gif" border=0></a>
<?php } // Show if not last page ?>
</td>
</tr>
</table>
</p>
<?php do {
if ($pageNum_rsNav=='-1') { ?>
<p><?php echo $row_rsThumb['ImageID']; ?>, <?php echo $row_rsThumb['im_name']; ?>.</p>
<?php } else { ?>
<p><?php echo $row_rsNav['ImageID']; ?>, <?php echo $row_rsNav['im_name']; ?>.</p>
<?php }} while ($row_rsNav = mysql_fetch_assoc($rsNav)); ?>
</body>
</html>
<?php
mysql_free_result($rsThumb);
mysql_free_result($rsNav);
?>
Thanks to all,
MArc-André
