Celauran wrote:jonnyfortis wrote:
Code: Select all
<? if ($row_rsProd['catID'] == 31):
?>
<a href="../SS15/SS15product-detail.php?ItemID=3062"><img src="../images/SS15/thumbs/3062.jpg"/></a>
<?php endif;?>
there is other code around it like a loop etc but this is the bit i think is the issue
Nothing wrong with that bit of code. Have you inspected the value of $row_rsProd['catID']? Have you confirmed that the query actually returned results?
yes i am still trying to find out when it will show on the page. it doesnt show in certain parts.. very stranged
if i place it above all the other code it show but if i place it at the bottom of the page where i need it ..it doesnt. i will show you the whole page because there are some loops in the page but that should effect it
it works if i put it within the loop but it then show the item 4 time which is no good
Code: Select all
<? if ($row_rsProd['catID'] != 44):
?>
<?php if ($totalRows_rsProd == 0) { // Show if recordset empty ?>
<span class="headerRED">
<br />
No Products Found
<?php } // Show if recordset empty ?>
</span>
<?php if ($totalRows_rsProd > 0) { // Show if recordset not empty ?>
<table border="0" class="maintext">
<tr>
<td><?php if ($pageNum_rsProd > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsProd=%d%s", $currentPage, 0, $queryString_rsProd); ?>">First</a>
<?php } // Show if not first page ?></td>
<td><?php if ($pageNum_rsProd > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsProd=%d%s", $currentPage, max(0, $pageNum_rsProd - 1), $queryString_rsProd); ?>">Previous</a>
<?php } // Show if not first page ?></td>
<td><?php if ($pageNum_rsProd < $totalPages_rsProd) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsProd=%d%s", $currentPage, min($totalPages_rsProd, $pageNum_rsProd + 1), $queryString_rsProd); ?>">Next</a>
<?php } // Show if not last page ?></td>
<td><?php if ($pageNum_rsProd < $totalPages_rsProd) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsProd=%d%s", $currentPage, $totalPages_rsProd, $queryString_rsProd); ?>">Last</a>
<?php } // Show if not last page ?></td>
</tr>
</table>
</p>
<table cellpadding="0" cellspacing="0" >
<tr>
<?php
$rsProd_endRow = 0;
$rsProd_columns = 4; // number of columns
$rsProd_hloopRow1 = 0; // first row flag
do {
if($rsProd_endRow == 0 && $rsProd_hloopRow1++ != 0) echo "<tr>";
?>
<td width="250" height="250" align="right" valign="bottom"><a href="../SS15/SS15product-detail.php?ItemID=<?php echo $row_rsProd['ItemID']; ?>"><div class="my-div" style="background-image:url('../images/SS15/thumbs/<?php echo $row_rsProd['Image']; ?>')"><br /><br /><br /><br />
<br />
<br />
<?php if ($row_rsProd['OutOfStock'] == 1): ?><img src="../images/sold-out.png" alt="sold out" width="100" height="100" align="right" /><?php endif;?></div>
<span class="strangelove"></span>
</a>
</td>
<?php $rsProd_endRow++;
if($rsProd_endRow >= $rsProd_columns) {
?>
</tr>
<?php
$rsProd_endRow = 0;
}
} while ($row_rsProd = mysql_fetch_assoc($rsProd));
if($rsProd_endRow != 0) {
while ($rsProd_endRow < $rsProd_columns) {
echo("<td> </td>");
$rsProd_endRow++;
}
echo("</tr>");
}?><br />
</table>
<table border="0" class="maintext">
<tr>
<td><?php if ($pageNum_rsProd > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsProd=%d%s", $currentPage, 0, $queryString_rsProd); ?>">First</a>
<?php } // Show if not first page ?></td>
<td><?php if ($pageNum_rsProd > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsProd=%d%s", $currentPage, max(0, $pageNum_rsProd - 1), $queryString_rsProd); ?>">Previous</a>
<?php } // Show if not first page ?></td>
<td><?php if ($pageNum_rsProd < $totalPages_rsProd) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsProd=%d%s", $currentPage, min($totalPages_rsProd, $pageNum_rsProd + 1), $queryString_rsProd); ?>">Next</a>
<?php } // Show if not last page ?></td>
<td><?php if ($pageNum_rsProd < $totalPages_rsProd) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsProd=%d%s", $currentPage, $totalPages_rsProd, $queryString_rsProd); ?>">Last</a>
<?php } // Show if not last page ?></td>
</tr>
</table>
<?php } // Show if recordset not empty ?><?php endif;?>
<? if ($row_rsProd['catID'] == 44):
?>
<div id="jackets"><a href="../SS15/SS15product-detail.php?ItemID=3036"><img src="../images/SS15/3036L.jpg" width="400" height="400" alt="jackets" /></a>
<a href="../SS15/SS15product-detail.php?ItemID=3037"><img src="../images/SS15/3037L.jpg" width="400" height="400" alt="jackets2" /></a><?php endif;?>
<? if ($row_rsProd['catID'] == 31):
?><a href="../SS15/SS15product-detail.php?ItemID=3061"><img src="../images/SS15/thumbs/3061.jpg"/></a><?php endif;?>
<? if ($row_rsProd['catID'] == 31):
?>
<a href="../SS15/SS15product-detail.php?ItemID=3062"><img src="../images/SS15/thumbs/3062.jpg"/></a>
<?php endif;?>
<? if ($row_rsProd['catID'] == 36):
?>
<a href="../SS15/SS15product-detail.php?ItemID=3061"><img src="../images/SS15/3061.jpg"/></a>
<?php endif;?>
<? if ($row_rsProd['catID'] == 36):
?>
<a href="../SS15/SS15product-detail.php?ItemID=3062"><img src="../images/SS15/3062.jpg"/></a>
<?php endif;?></div>
</p>
</div>