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>'; } ?>


Reply With Quote
