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 ArrivalsDear Valued customer,
At the stable of Upkar-Darpan Group, the newest addition is Upkar Stationery Pvt. Ltd. that comes with a legacy of innovation and quality, an ambitious project to manufacture range of Stationery products in India that is all set to deliver global standard stationery.
Among the publishing fraternity, Mr. Mahendra Jain is acknowledged as a pioneer and visionary who honestly believed in setting editorial standards, building huge production capacities and bringing innovations in the publishing industry ahead of times.
echo $msg?>