Created a product carousel here
HERE
however the products have stopped loading into it!
any suggestions?
Here is the code from tpl_product_info_display.php
Code:
require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_CATEGORY_ICON_DISPLAY));
?>
<h1><?php echo $category_icon_display_name;?></h1>
<?php
$listing_sql2 = "select p.products_id, p.products_image, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id
from " . TABLE_PRODUCTS . " p, " .
TABLE_PRODUCTS_TO_CATEGORIES . " p2c
where p.products_status = 1
and p.products_id = p2c.products_id
and p.products_id != '". (int)$_GET['products_id'] ."'
and p2c.categories_id = '" . (int)$current_category_id . "'";
$listing_result = $db->Execute($listing_sql2);
$listing_result2 = $db->Execute($listing_sql2);
$j='1';
while (!$listing_result2->EOF) {
$j++;
$listing_result2->MoveNext();
}
if($listing_result and $j >1){
?>
<script type="text/javascript">
//jQuery.noConflict();
jQuery(document).ready(function() {
jQuery('#mycarousel').jcarousel({
visible: 4
});
});
</script>
<?php
echo '<div style="width:920px;">
<ul id="mycarousel" class="jcarousel-skin-tango">';
while (!$listing_result->EOF) {
echo '<li><a href="' . zen_href_link(zen_get_info_page($listing_result->fields['products_id']), 'cPath=' . $_GET['cPath'] . '&products_id=' . $listing_result->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $listing_result->fields['products_image'], $listing_result->fields['products_name'], '180', '140') . '</a></li>';
//echo $listing_result->fields['products_id'] . '<BR>';
$listing_result->MoveNext();
}
echo '</ul>';
}
?>
Bookmarks