Our Categories
-
$n=0;
$sql = "select * from category where cat_active=1 and cat_lang='E' and cat_store=$StoreId order by cat_seq, cat_title";
$catList = mysql_query($sql);
while($row=mysql_fetch_array($catList))
{
$sql = "select * from subcategory where subcat_active=1 and cat_id=".$row["cat_id"]." order by subcat_seq, subcat_title";
$subcatList = mysql_query($sql);
$num_rows = mysql_num_rows($subcatList);
if ($num_rows > 0)
{
$n=$n+1;
?>
-
" data-toggle="collapse" class=" echo ($row["cat_id"]==get("cat")?"active":"collapse") ?>"> echo $row["cat_title"];?>
- " id=" echo $row["cat_id"];?>">
while($row1=mysql_fetch_array($subcatList))
{
?>
- "> echo $row1["subcat_title"];?> } print "
";
}
else
{
?>
- "> echo $row["cat_title"];?> } } ?>
Best Sellers
-
$sql = "select * from products where prod_hot=1 and prod_active=1 and prod_store=$StoreId order by prod_seq limit 0,10";
$prod_arr = mysql_query($sql);
while($row=mysql_fetch_array($prod_arr))
{
//$pic = getpic("prod_pic/small/". trim($row["prod_pic"]));
$pid=$row["prod_id"];
// Get product Rating
$rating = getProdRatings($pid);
$avg = $rating["Average"];
$rCount = $rating["ReviewsCnt"];
// End Ratings
$MRP = round(GetCurrencyRate($row["prod_id"],"M") * $row["prod_rate"],0);
$PrintMRP = round(GetCurrencyRate($row["prod_id"],"S") * $row["prod_sprate"],0);
$SalePrice = GetFinalPrice($row["prod_id"], $MRP);
$Discount=0;
if ($PrintMRP > 0)
$Discount = round((($PrintMRP - $SalePrice) * 100) / $PrintMRP);
?>
-
$sql="select * from product_images where active=1 and prod_id=".$row["prod_id"] ." order by cover_img desc limit 0,1"; $query1=mysql_query($sql); $cnt = mysql_num_rows($query1); $row1=mysql_fetch_array($query1); $prod_pic = $row1["image_name"]; $pic="prod_pic/small/$prod_pic"; $pic = getpic($pic); ?> " title=" echo $row["prod_name"]?>">
">
} ?>
$sql = "select * from products where prod_new=1 and prod_active=1 and prod_store=$StoreId order by prod_seq limit 0,10";
$prod_arr = mysql_query($sql);
while($row=mysql_fetch_array($prod_arr))
{
//$pic = getpic("prod_pic/small/". trim($row["prod_pic"]));
$pid=$row["prod_id"];
// Get product Rating
$rating = getProdRatings($pid);
$avg = $rating["Average"];
$rCount = $rating["ReviewsCnt"];
// End Ratings
$MRP = round(GetCurrencyRate($row["prod_id"],"M") * $row["prod_rate"],0);
$PrintMRP = round(GetCurrencyRate($row["prod_id"],"S") * $row["prod_sprate"],0);
$SalePrice = GetFinalPrice($row["prod_id"], $MRP);
$Discount=0;
if ($PrintMRP > 0)
$Discount = round((($PrintMRP - $SalePrice) * 100) / $PrintMRP);
$sql="select * from product_images where active=1 and prod_id=".$row["prod_id"] ." order by cover_img desc limit 0,1";
$query1=mysql_query($sql);
$cnt = mysql_num_rows($query1);
$row1=mysql_fetch_array($query1);
?>
" title=" echo $row["prod_name_e"]?>">
$prod_pic = $row1["image_name"];
$pic="prod_pic/small/$prod_pic";
$pic = getpic($pic);
?>
">
} ?>
What’s New
2015 First Arrivals
include("include/insert_feedback.php"); ?>
echo $msg?>