$IBArr = DbHelper::fetchAll($resIB); /* Other Intrested Items Bought By */ //$resOI = DbHelper::execute("SELECT p.product_id,p.product_name,op.image_small,op.image_big FROM ".$tableprefix."products p LEFT JOIN ".$tableprefix."product_options op ON p.product_id = op.product_id WHERE p.vIntrest='Y' AND p.product_id != '".$_GET['productid']."' GROUP BY p.product_id LIMIT 0,12"); $sql_interest = "SELECT p.product_id,p.product_name,op.image_small,op.image_big FROM " . $tableprefix . "products p\n LEFT JOIN " . $tableprefix . "product_options op ON p.product_id = op.product_id\n INNER JOIN " . $tableprefix . "categories c ON c.category_id = p.product_category\n WHERE p.vIntrest='Y' AND p.product_id != '" . mysql_real_escape_string($_GET['productid']) . "'\n AND p.deleted = 'N' AND c.vEnable='Y' GROUP BY p.product_id LIMIT 0,12"; $resOI = DbHelper::execute($sql_interest); $OIArr = DbHelper::fetchAll($resOI); /* display the active template */ $active_template = displayTemplate(); include "includes/htmltop.php"; /* Top File Name */ include_once "includes/" . $active_template[0]; $quantity = getWholesaleProductCount($prow["product_option_id"]); // Check product is whole sale item or not $eWholesaleItem = isWholesaleItem($productid); //Check Selected Option Added to Wish List $wishItemCount_Product = getWishItemsCount_Product($productid, $prow["product_option_id"]); // Current Stock Available for a product $currentStockAvailable = getCurrentStockAvailable($productid, $prow["product_option_id"]); ?> <!--<script type="text/javascript" src="<?php echo SITE_URL; ?> /jCarousel/jcarouselmin.js"></script> <script type="text/javascript" src="<?php echo SITE_URL; ?> /jCarousel/jcarousel.responsive.js"></script>-->
$product_image = $rw["image_small"]; } elseif ($rw["image_big"] != "") { $product_image = $rw["image_big"]; } else { $product_image = $rw["smallimage"]; } if ($product_image == "") { $imageurl = $prodimagedir . "noimage.jpg"; } else { if (strstr($product_image, "http://")) { $imageurl = $product_image; } else { $imageurl = $prodimagedir . $product_image; } } $wishItemCount_Product = getWishItemsCount_Product($product_id, $product_option_id); ?> <input type="hidden" value="" name="txtQty_<?php echo $cntt; ?> " id="txtQty_<?php echo $cntt; ?> " /> <input type="hidden" value="<?php echo $rw["cart_id"]; ?> " name="cartid_<?php echo $rw["cart_id"]; ?> " id="cartid_<?php