$i=1;
$qry1="select * from category where pcatid='0' order by catid";
$rqry1=mysqli_query($connect,$qry1);
if(mysqli_num_rows($rqry1)>0)
{
while($row=mysqli_fetch_array($rqry1))
{
$sqlpp="select *from indexpg where cat_id=$row[catid] order by rand() limit 0,6";
$qrypp=mysqli_query($connect,$sqlpp);
$rowpp=mysqli_fetch_array($qrypp)
?>
| if($rowpp["imgpath"]){ ?>
} else { ?>
}?> |
$cat=$row["category"];
?>
print $cat.''.$cat1 .''.$cat2 ;?> |
if($i<3){
$i++;
?> |
}else{
$i++;
$i=1;
echo " ";
}?>
}}
else
{
echo ("Product Not found ");
}
?>
|