$sql="select M.Manufacturer_Name,P.Product_Id,subcat.SubCategory_Name ,P.Product_Thumbnail,P.Product_Name,P.Product_Code ,P.Product_Sale_Price,
P.Product_Stock ,P.Product_Pack,P.Product_SubCategory,P.Product_Description, P.productUrl,subcat.SubCategory_Order
From related_categories R,products P,subcategories subcat,manufacturers M
where P.Product_Status='Active' and P.Product_SubCategory=R.Sub_Category and subcat.SubCategory_Id =P.Product_SubCategory
and R.Parent_Category=".$Rssub[$j]["Category_Id"]." and M.Manufacturer_Id=P.Product_Manufacturer order by subcat.SubCategory_Order,P.Product_Order limit 0,5";
$Rs=selectMultiRecords($sql);
for($p=0;$p
$sql="select M.Manufacturer_Name,P.Product_Id,subcat.SubCategory_Name ,P.Product_Thumbnail,P.Product_Name,P.Product_Code ,P.Product_Sale_Price,
P.Product_Stock ,P.Product_Pack,P.Product_SubCategory,P.Product_Description, P.productUrl,subcat.SubCategory_Order
From related_categories R,products P,subcategories subcat,manufacturers M
where P.Product_Status='Active' and P.Product_SubCategory=R.Sub_Category and subcat.SubCategory_Id =P.Product_SubCategory
and R.Parent_Category=".$Rssub[$j]["Category_Id"]." and M.Manufacturer_Id=P.Product_Manufacturer order by subcat.SubCategory_Order,P.Product_Order limit 0,5";
$Rs=selectMultiRecords($sql);
for($p=0;$p
$sql="select M.Manufacturer_Name,P.Product_Id,subcat.SubCategory_Name ,P.Product_Thumbnail,P.Product_Name,P.Product_Code ,P.Product_Sale_Price,
P.Product_Stock ,P.Product_Pack,P.Product_SubCategory,P.Product_Description, P.productUrl,subcat.SubCategory_Order
From related_categories R,products P,subcategories subcat,manufacturers M
where P.Product_Status='Active' and P.Product_SubCategory=R.Sub_Category and subcat.SubCategory_Id =P.Product_SubCategory
and R.Parent_Category=".$Rssub[$j]["Category_Id"]." and M.Manufacturer_Id=P.Product_Manufacturer order by subcat.SubCategory_Order,P.Product_Order limit 0,5";
$Rs=selectMultiRecords($sql);
for($p=0;$p
$sql="select M.Manufacturer_Name,P.Product_Id,subcat.SubCategory_Name ,P.Product_Thumbnail,P.Product_Name,P.Product_Code ,P.Product_Sale_Price,
P.Product_Stock ,P.Product_Pack,P.Product_SubCategory,P.Product_Description, P.productUrl,subcat.SubCategory_Order
From related_categories R,products P,subcategories subcat,manufacturers M
where P.Product_Status='Active' and P.Product_SubCategory=R.Sub_Category and subcat.SubCategory_Id =P.Product_SubCategory
and R.Parent_Category=".$Rssub[$j]["Category_Id"]." and M.Manufacturer_Id=P.Product_Manufacturer order by subcat.SubCategory_Order,P.Product_Order limit 0,5";
$Rs=selectMultiRecords($sql);
for($p=0;$p
$sql="select M.Manufacturer_Name,P.Product_Id,subcat.SubCategory_Name ,P.Product_Thumbnail,P.Product_Name,P.Product_Code ,P.Product_Sale_Price,
P.Product_Stock ,P.Product_Pack,P.Product_SubCategory,P.Product_Description, P.productUrl,subcat.SubCategory_Order
From related_categories R,products P,subcategories subcat,manufacturers M
where P.Product_Status='Active' and P.Product_SubCategory=R.Sub_Category and subcat.SubCategory_Id =P.Product_SubCategory
and R.Parent_Category=".$Rssub[$j]["Category_Id"]." and M.Manufacturer_Id=P.Product_Manufacturer order by subcat.SubCategory_Order,P.Product_Order limit 0,5";
$Rs=selectMultiRecords($sql);
for($p=0;$p
$sql="select M.Manufacturer_Name,P.Product_Id,subcat.SubCategory_Name ,P.Product_Thumbnail,P.Product_Name,P.Product_Code ,P.Product_Sale_Price,
P.Product_Stock ,P.Product_Pack,P.Product_SubCategory,P.Product_Description, P.productUrl,subcat.SubCategory_Order
From related_categories R,products P,subcategories subcat,manufacturers M
where P.Product_Status='Active' and P.Product_SubCategory=R.Sub_Category and subcat.SubCategory_Id =P.Product_SubCategory
and R.Parent_Category=".$Rssub[$j]["Category_Id"]." and M.Manufacturer_Id=P.Product_Manufacturer order by subcat.SubCategory_Order,P.Product_Order limit 0,5";
$Rs=selectMultiRecords($sql);
for($p=0;$p
$sql="select M.Manufacturer_Name,P.Product_Id,subcat.SubCategory_Name ,P.Product_Thumbnail,P.Product_Name,P.Product_Code ,P.Product_Sale_Price,
P.Product_Stock ,P.Product_Pack,P.Product_SubCategory,P.Product_Description, P.productUrl,subcat.SubCategory_Order
From related_categories R,products P,subcategories subcat,manufacturers M
where P.Product_Status='Active' and P.Product_SubCategory=R.Sub_Category and subcat.SubCategory_Id =P.Product_SubCategory
and R.Parent_Category=".$Rssub[$j]["Category_Id"]." and M.Manufacturer_Id=P.Product_Manufacturer order by subcat.SubCategory_Order,P.Product_Order limit 0,5";
$Rs=selectMultiRecords($sql);
for($p=0;$p
$sql="select M.Manufacturer_Name,P.Product_Id,subcat.SubCategory_Name ,P.Product_Thumbnail,P.Product_Name,P.Product_Code ,P.Product_Sale_Price,
P.Product_Stock ,P.Product_Pack,P.Product_SubCategory,P.Product_Description, P.productUrl,subcat.SubCategory_Order
From related_categories R,products P,subcategories subcat,manufacturers M
where P.Product_Status='Active' and P.Product_SubCategory=R.Sub_Category and subcat.SubCategory_Id =P.Product_SubCategory
and R.Parent_Category=".$Rssub[$j]["Category_Id"]." and M.Manufacturer_Id=P.Product_Manufacturer order by subcat.SubCategory_Order,P.Product_Order limit 0,5";
$Rs=selectMultiRecords($sql);
for($p=0;$p
$sql="select M.Manufacturer_Name,P.Product_Id,subcat.SubCategory_Name ,P.Product_Thumbnail,P.Product_Name,P.Product_Code ,P.Product_Sale_Price,
P.Product_Stock ,P.Product_Pack,P.Product_SubCategory,P.Product_Description, P.productUrl,subcat.SubCategory_Order
From related_categories R,products P,subcategories subcat,manufacturers M
where P.Product_Status='Active' and P.Product_SubCategory=R.Sub_Category and subcat.SubCategory_Id =P.Product_SubCategory
and R.Parent_Category=".$Rssub[$j]["Category_Id"]." and M.Manufacturer_Id=P.Product_Manufacturer order by subcat.SubCategory_Order,P.Product_Order limit 0,5";
$Rs=selectMultiRecords($sql);
for($p=0;$p
$sql="select M.Manufacturer_Name,P.Product_Id,subcat.SubCategory_Name ,P.Product_Thumbnail,P.Product_Name,P.Product_Code ,P.Product_Sale_Price,
P.Product_Stock ,P.Product_Pack,P.Product_SubCategory,P.Product_Description, P.productUrl,subcat.SubCategory_Order
From related_categories R,products P,subcategories subcat,manufacturers M
where P.Product_Status='Active' and P.Product_SubCategory=R.Sub_Category and subcat.SubCategory_Id =P.Product_SubCategory
and R.Parent_Category=".$Rssub[$j]["Category_Id"]." and M.Manufacturer_Id=P.Product_Manufacturer order by subcat.SubCategory_Order,P.Product_Order limit 0,5";
$Rs=selectMultiRecords($sql);
for($p=0;$p