(Resolvido) Problemas com imagem

[Marcos_Vinicius]

Estou com um problema para mostar as fotos dos produtos, a mesma imagem aparece em todos os produtos cadastrados. Segue abaixo o código das duas páginas

código produtos2.php

<?php require_once('Connections/conexao.php'); ?> 
<?php
$currentPage = $_SERVER['PHP_SELF'];

$maxRows_Recordset1 = 5;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$colname_Recordset1 = "1";
if (isset($_GET['cod_cat'])) {
  $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['cod_cat'] : addslashes($_GET['cod_cat']);
}
mysql_select_db($database_conexao, $conexao);
$query_Recordset1 = sprintf("SELECT * FROM produtos WHERE cod_cat = %s", $colname_Recordset1);
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $conexao) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recordset1") == false && 
        stristr($param, "totalRows_Recordset1") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Recordset1 = "&" . implode("&", $newParams);
  }
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>
&lt;script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
<div align="center">
  <?php if ($totalRows_Recordset1 == 0) { // Show if recordset empty ?>
  No momento n&atilde;o dispomos de nenhum produto para essa categoria. 
  <?php } // Show if recordset empty ?>
  <br>
  <?php do { ?>
  <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?>
  <table width="654" border="1" align="center">
    <tr> 
      <td width="305" rowspan="2">
<div align="center"><img src="<?php echo $row_Recordset1['fot_peq'];?>"></div></td>
      <td width="333"><div align="center"><strong><?php echo $row_Recordset1['nome_prod']; ?></strong></div></td>
    </tr>
    <tr> 
      <td><div align="center"><?php echo $row_Recordset1['descricao']; ?></div></td>
    </tr>
    <tr> 
      <td><div align="center"><a href="java script:;" onClick="MM_openBrWindow('fotos.php?cod_prod=<?php echo $row_Recordset1['cod_prod']; ?>','','scrollbars=yes,width=350,height=400,left=1o,top=10')">Mais 
          fotos</a></div></td>
      <td rowspan="2"><div align="center">R$<?php echo $row_Recordset1['valor']; ?>,00</div></td>
    </tr>
    <tr> 
      <td><center>


      <FORM METHOD=POST ACTION="comprar.php">
      <INPUT TYPE="hidden" name="session_id" value="<?php echo $_SESSION["id"]; ?>">
      <INPUT TYPE="hidden" name="valor" value="<?php echo $row_Recordset1['valor']; ?>">
      <INPUT TYPE="hidden" name="nome_prod" value="<?php echo $row_Recordset1['nome_prod']; ?>">
            Quantidade 
            <select name="quantidade" id="quantidade">
              <option value="1">1</option>
              <option value="2">2</option>
              <option value="3">3</option>
              <option value="4">4</option>
              <option value="5">5</option>
              <option value="6">6</option>
              <option value="7">7</option>
              <option value="8">8</option>
              <option value="9">9</option>
              <option value="10">10</option>
            </select>
            <INPUT TYPE="submit" value="Comprar">
      </FORM>
         
      
        </center></td>
    </tr>
  </table>
  <br>
  <?php } // Show if recordset not empty ?>
  <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); 
mysql_free_result($Recordset1);
?>
  <p>&nbsp; Registros <?php echo ($startRow_Recordset1 + 1) ?> a <?php echo min($startRow_Recordset1 + $maxRows_Recordset1, $totalRows_Recordset1) ?> de <?php echo $totalRows_Recordset1 ?> 
  <table border="0" width="50%" align="center">
    <tr> 
      <td width="23%" align="center"> <?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
        <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, 0, $queryString_Recordset1); ?>">Primeiro</a> 
        <?php } // Show if not first page ?> </td>
      <td width="31%" align="center"> <?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
        <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>">Retornar</a> 
        <?php } // Show if not first page ?> </td>
      <td width="23%" align="center"> <?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
        <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>">Avan&ccedil;ar</a> 
        <?php } // Show if not last page ?> </td>
      <td width="23%" align="center"> <?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
        <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, $totalPages_Recordset1, $queryString_Recordset1); ?>">&Uacute;ltimo</a> 
        <?php } // Show if not last page ?> </td>
    </tr>
  </table></p>
  </div>

código fotos.php

<?php require_once('Connections/conexao.php'); ?>
<?php
$colname_Recordset1 = "1";
if (isset($_GET['cod_prod'])) {
  $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['cod_prod'] : addslashes($_GET['cod_prod']);
}
mysql_select_db($database_conexao, $conexao);
$query_Recordset1 = sprintf("SELECT fot_1, fot_2, fot_3 FROM produtos WHERE cod_prod = %s", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $conexao) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<html>
<head>
<title>Loja Virtual</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF">
<p align="center"><br>
  <img src="<?php echo $row_Recordset1['fot_1']; ?>"> 
</p>
<p align="center"><img src="<?php echo $row_Recordset1['fot_2']; ?>"></p>
<p align="center"><img src="<?php echo $row_Recordset1['fot_3']; ?>"></p>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

Editado Outubro 17, 2009 por Marcos_Vinicius