0){
$sql1="SELECT * FROM `departicles` WHERE `landid`='$categorylandid' AND `subsubgroupid`='$thiscatid' ORDER BY `id` DESC limit 0,5";
$query1=mysql_query($sql1);
$cntprod=1;
while($rowprod=mysql_fetch_array($query1)){
$productid[$cntcateg][$cntprod]=$rowprod["id"];
$prodname[$cntcateg][$cntprod]=$rowprod["title"];
$prodsalary[$cntcateg][$cntprod]=$rowprod["sale_price"];
$prodoldprice[$cntcateg][$cntprod]=$rowprod["oldprice"];
$new[$cntcateg][$cntprod]=$rowprod["new"];
$prodpathurl[$cntcateg][$cntprod]=$rowprod["pathurl"];
$thisid=$productid[$cntcateg][$cntprod];
$sqlimage="SELECT * FROM gallery WHERE `landid`='$categorylandid' AND `subsubgroupid`='$thiscatid' AND `articleid`='$thisid' ORDER BY `rank` ASC Limit 0,2";
$queryimage=mysql_query($sqlimage);
$nbrowimage=mysql_num_rows($queryimage);
if($nbrowimage>0){
$kimage=1;
while($rowimage=mysql_fetch_array($queryimage)){
$prodimg[$cntcateg][$cntprod][$kimage]=$rowimage["image"];
$kimage++;
}
}
$cntprod++;
}
$nbprodofcat[$cntcateg]=$cntprod;
$cntcateg++;
}
//}
}
// get last five products
$sqllast5prod="SELECT * FROM `departicles` WHERE `landid`=7 ORDER BY `id` DESC LIMIT 0,5";
$querylast5prod=mysql_query($sqllast5prod);
$cnt5last=1;
while($rowlast5prod=mysql_fetch_array($querylast5prod)){
$idlast5prod[$cnt5last]=$rowlast5prod["id"];
$titlelast5prod[$cnt5last]=$rowlast5prod["title"];
$pathurllast5prod[$cnt5last]=$rowlast5prod["pathurl"];
$pricelast5prod[$cnt5last]=$rowlast5prod["sale_price"];
$pricelast5prodold[$cnt5last]=$rowlast5prod["oldprice"];
$thisid=$idlast5prod[$cnt5last];
$sqlimage="SELECT * FROM gallery WHERE `landid`=7 AND `articleid`='$thisid' ORDER BY `rank` ASC Limit 0,2";
$queryimage=mysql_query($sqlimage);
$nbrowimage=mysql_num_rows($queryimage);
if($nbrowimage>0){
$kimage=1;
while($rowimage=mysql_fetch_array($queryimage)){
$imagelast5prod[$cnt5last][$kimage]=$rowimage["image"];
$kimage++;
}
}
$cnt5last++;
}
// get top selling five products
$sqllast5prod="SELECT * FROM `departicles` WHERE `landid`=7 ORDER BY `selled_qty` DESC LIMIT 0,5";
$querylast5prod=mysql_query($sqllast5prod);
$cntlastselling=1;
while($rowlast5prod=mysql_fetch_array($querylast5prod)){
$idlast5selling[$cntlastselling]=$rowlast5prod["id"];
$titlelast5selling[$cntlastselling]=$rowlast5prod["title"];
$pathurllast5selling[$cntlastselling]=$rowlast5prod["pathurl"];
//$imagelast5selling[$cntlastselling]=$rowlast5prod["image"];
$pricelast5selling[$cntlastselling]=$rowlast5prod["sale_price"];
$pricelast5sellingold[$cntlastselling]=$rowlast5prod["oldprice"];
$thisid=$idlast5selling[$cntlastselling];
$sqlimage="SELECT * FROM gallery WHERE `landid`=7 AND `articleid`='$thisid' ORDER BY `rank` ASC Limit 0,2";
$queryimage=mysql_query($sqlimage);
$nbrowimage=mysql_num_rows($queryimage);
if($nbrowimage>0){
$kimage=1;
while($rowimage=mysql_fetch_array($queryimage)){
$imagelast5selling[$cntlastselling][$kimage]=$rowimage["image"];
$kimage++;
}
}
$cntlastselling++;
}
// get meta
$sqlmeta="SELECT * FROM `meta` WHERE `landid`='1'";
$querymeta=mysql_query($sqlmeta);
$rowmeta=mysql_fetch_array($querymeta);
$metadesc=$rowmeta["description"];
$metakeyword=$rowmeta["keywords"];
$displaymenu=1;
$iPod = stripos($_SERVER['HTTP_USER_AGENT'],"iPod");
$iPhone = stripos($_SERVER['HTTP_USER_AGENT'],"iPhone");
$iPad = stripos($_SERVER['HTTP_USER_AGENT'],"iPad");
if($iPod OR $iPhone OR $iPad) $overflow="scroll";
else $overflow="hidden";
?>
<? echo($headtitle) ?>
 ?>imagelib/arrowleft.png "Scroll Left")
 ?>imagelib/arrowright.png "Scroll Right")
 ?>imagelib/newlogo.png)