$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