$i = 0;
$j = 0;
$k = 0;
$l = 0;
$query="SELECT * from tbl_category where category_web='CRIDS' and category_status='1' order by category_order limit 3";
$result = mysqli_query($con, $query);
$cid = array();
while($row = mysqli_fetch_assoc($result))
{
$cid[]=$row['category_id'];
?>
$query_docs = "SELECT * from tbl_docs where category_id='".$row['category_id']."' order by docs_order";
$result_docs = mysqli_query($con, $query_docs);
while($row_docs = mysqli_fetch_assoc($result_docs))
{
$sub_category_id=$row_docs['sub_category_id'];
$child_category_id=$row_docs['child_category_id'];
$category_id=$row_docs['category_id'];
?>
if($sub_category_id=='0' and $child_category_id=='0')
{
?>
if($row_docs['docs_url']=="")
{
?>
}
else
{
?>
}
?>
}
?>
}
?>
//$query_sub_cat = "SELECT tbl_docs.*,tbl_sub_category.* from tbl_docs,tbl_sub_category where tbl_docs.sub_category_id=tbl_sub_category.sub_category_id and tbl_docs.sub_category_id='".$sub_category_id."' and tbl_docs.docs_status='1' and tbl_sub_category.sub_category_status='1'";
$query_sub_cat = "SELECT distinct(sub_category_id) from tbl_sub_category where category_id='".$row['category_id']."' order by sub_category_order";
$result_sub_cat = mysqli_query($con, $query_sub_cat);
while($row_sub_cat = mysqli_fetch_assoc($result_sub_cat))
{
if($sub_category_id!='0' and $child_category_id=='0')
{
?>
$query_sc = "SELECT * from tbl_sub_category where sub_category_id='".$row_sub_cat['sub_category_id']."' and category_id='".$category_id."' and sub_category_status='1'";
$result_sc = mysqli_query($con, $query_sc);
while($row_sc = mysqli_fetch_assoc($result_sc))
{
$sub_id=$row_sc['sub_category_id'];
?>
$m=0;
$query_docs2 = "SELECT * from tbl_docs where sub_category_id='".$sub_id."' and docs_status='1'";
$result_docs2 = mysqli_query($con, $query_docs2);
while($row_docs2 = mysqli_fetch_assoc($result_docs2))
{
?>
if($row_docs2['docs_url']=="")
{
?>
}
else
{
?>
}
?>
$m++;
}
?>
}
$k++;
?>
}
?>
}
?>
$query_docs2 = "SELECT distinct(sub_category_id) from tbl_docs where category_id='".$row['category_id']."' order by docs_order";
$result_docs2 = mysqli_query($con, $query_docs2);
while($row_docs2 = mysqli_fetch_assoc($result_docs2))
{
$sub_category_id2=$row_docs2['sub_category_id'];
$child_category_id2=$row_docs2['child_category_id'];
$category_id2=$row_docs2['category_id'];
?>
if($sub_category_id!='0' and $child_category_id!='0')
{
?>
$query_sc = "SELECT * from tbl_sub_category where sub_category_id='".$sub_category_id2."' and category_id='".$row['category_id']."' and sub_category_status='1'";
$result_sc = mysqli_query($con, $query_sc);
while($row_sc = mysqli_fetch_assoc($result_sc))
{
$sub_id=$row_sc['sub_category_id'];
?>
$a=0;
$query_cc = "SELECT * from tbl_child_category where sub_category_id='".$sub_id."' and category_id='".$row['category_id']."' and child_category_status='1'";
$result_cc = mysqli_query($con, $query_cc);
while($row_cc = mysqli_fetch_assoc($result_cc))
{
$child_id=$row_cc['child_category_id'];
?>
$m=0;
?>
$query_docs1 = "SELECT * from tbl_docs where sub_category_id='".$sub_id."' and child_category_id='".$child_id."' and docs_status='1'";
$result_docs1 = mysqli_query($con, $query_docs1);
while($row_docs1 = mysqli_fetch_assoc($result_docs1))
{
?>
if($row_docs1['docs_url']=="")
{
?>
}
else
{
?>
}
?>
}
?>
$m++;
$a++;
}
?>
}
}
$l++;
}
?>
$i++;
$j++;
$l++;
}
$cid=implode(', ', $cid);
?>
$i = 20;
$j = 20;
$k = 20;
$l = 20;
$query="SELECT * from tbl_category where category_web='CRIDS' and category_status='1' and category_id not in('" . str_replace(",", "','", $cid) . "') order by category_order limit 3";
$result = mysqli_query($con, $query);
$cid1 = array();
while($row = mysqli_fetch_assoc($result))
{
$cid1[]=$row['category_id'];
?>
$query_docs = "SELECT * from tbl_docs where category_id='".$row['category_id']."' order by docs_order";
$result_docs = mysqli_query($con, $query_docs);
while($row_docs = mysqli_fetch_assoc($result_docs))
{
$sub_category_id=$row_docs['sub_category_id'];
$child_category_id=$row_docs['child_category_id'];
$category_id=$row_docs['category_id'];
?>
if($sub_category_id=='0' and $child_category_id=='0')
{
?>
if($row_docs['docs_url']=="")
{
?>
}
else
{
?>
}
?>
}
?>
}
?>
//$query_sub_cat = "SELECT tbl_docs.*,tbl_sub_category.* from tbl_docs,tbl_sub_category where tbl_docs.sub_category_id=tbl_sub_category.sub_category_id and tbl_docs.sub_category_id='".$sub_category_id."' and tbl_docs.docs_status='1' and tbl_sub_category.sub_category_status='1'";
$query_sub_cat = "SELECT distinct(sub_category_id) from tbl_sub_category where category_id='".$row['category_id']."' order by sub_category_order";
$result_sub_cat = mysqli_query($con, $query_sub_cat);
while($row_sub_cat = mysqli_fetch_assoc($result_sub_cat))
{
if($sub_category_id!='0' and $child_category_id=='0')
{
?>
$query_sc = "SELECT * from tbl_sub_category where sub_category_id='".$row_sub_cat['sub_category_id']."' and category_id='".$category_id."' and sub_category_status='1'";
$result_sc = mysqli_query($con, $query_sc);
while($row_sc = mysqli_fetch_assoc($result_sc))
{
$sub_id=$row_sc['sub_category_id'];
?>
$m=20;
$query_docs2 = "SELECT * from tbl_docs where sub_category_id='".$sub_id."' and docs_status='1'";
$result_docs2 = mysqli_query($con, $query_docs2);
while($row_docs2 = mysqli_fetch_assoc($result_docs2))
{
?>
if($row_docs2['docs_url']=="")
{
?>
}
else
{
?>
}
?>
$m++;
}
?>
}
$k++;
?>
}
?>
}
?>
$query_docs2 = "SELECT distinct(sub_category_id) from tbl_docs where category_id='".$row['category_id']."' order by docs_order";
$result_docs2 = mysqli_query($con, $query_docs2);
while($row_docs2 = mysqli_fetch_assoc($result_docs2))
{
$sub_category_id2=$row_docs2['sub_category_id'];
$child_category_id2=$row_docs2['child_category_id'];
$category_id2=$row_docs2['category_id'];
?>
if($sub_category_id!='0' and $child_category_id!='0')
{
?>
$query_sc = "SELECT * from tbl_sub_category where sub_category_id='".$sub_category_id2."' and category_id='".$row['category_id']."' and sub_category_status='1'";
$result_sc = mysqli_query($con, $query_sc);
while($row_sc = mysqli_fetch_assoc($result_sc))
{
$sub_id=$row_sc['sub_category_id'];
?>
$a=20;
$query_cc = "SELECT * from tbl_child_category where sub_category_id='".$sub_id."' and category_id='".$row['category_id']."' and child_category_status='1'";
$result_cc = mysqli_query($con, $query_cc);
while($row_cc = mysqli_fetch_assoc($result_cc))
{
$child_id=$row_cc['child_category_id'];
?>
$m=20;
?>
$query_docs1 = "SELECT * from tbl_docs where sub_category_id='".$sub_id."' and child_category_id='".$child_id."' and docs_status='1'";
$result_docs1 = mysqli_query($con, $query_docs1);
while($row_docs1 = mysqli_fetch_assoc($result_docs1))
{
?>
if($row_docs1['docs_url']=="")
{
?>
$cid2=$cid.",".$cid1;
$ni = 40;
$nj = 40;
$nk = 40;
$nl = 40;
$query="SELECT * from tbl_category where category_web='CRIDS' and category_status='1' and category_id not in('" . str_replace(",", "','", $cid2) . "') order by category_order limit 3";
$result = mysqli_query($con, $query);
$cid1 = array();
while($row = mysqli_fetch_assoc($result))
{
$cid1[]=$row['category_id'];
?>
$query_docs = "SELECT * from tbl_docs where category_id='".$row['category_id']."' order by docs_order";
$result_docs = mysqli_query($con, $query_docs);
while($row_docs = mysqli_fetch_assoc($result_docs))
{
$sub_category_id=$row_docs['sub_category_id'];
$child_category_id=$row_docs['child_category_id'];
$category_id=$row_docs['category_id'];
?>
if($sub_category_id=='0' and $child_category_id=='0')
{
?>
if($row_docs['docs_url']=="")
{
?>
}
else
{
?>
}
?>
}
?>
}
?>
//$query_sub_cat = "SELECT tbl_docs.*,tbl_sub_category.* from tbl_docs,tbl_sub_category where tbl_docs.sub_category_id=tbl_sub_category.sub_category_id and tbl_docs.sub_category_id='".$sub_category_id."' and tbl_docs.docs_status='1' and tbl_sub_category.sub_category_status='1'";
$query_sub_cat = "SELECT distinct(sub_category_id) from tbl_sub_category where category_id='".$row['category_id']."' order by sub_category_order";
$result_sub_cat = mysqli_query($con, $query_sub_cat);
while($row_sub_cat = mysqli_fetch_assoc($result_sub_cat))
{
if($sub_category_id!='0' and $child_category_id=='0')
{
?>
$query_sc = "SELECT * from tbl_sub_category where sub_category_id='".$row_sub_cat['sub_category_id']."' and category_id='".$category_id."' and sub_category_status='1'";
$result_sc = mysqli_query($con, $query_sc);
while($row_sc = mysqli_fetch_assoc($result_sc))
{
$sub_id=$row_sc['sub_category_id'];
?>
$m=40;
$query_docs2 = "SELECT * from tbl_docs where sub_category_id='".$sub_id."' and docs_status='1'";
$result_docs2 = mysqli_query($con, $query_docs2);
while($row_docs2 = mysqli_fetch_assoc($result_docs2))
{
?>
if($row_docs2['docs_url']=="")
{
?>
}
else
{
?>
}
?>
$m++;
}
?>
}
$k++;
?>
}
?>
}
?>
$query_docs2 = "SELECT distinct(sub_category_id) from tbl_docs where category_id='".$row['category_id']."' order by docs_order";
$result_docs2 = mysqli_query($con, $query_docs2);
while($row_docs2 = mysqli_fetch_assoc($result_docs2))
{
$sub_category_id2=$row_docs2['sub_category_id'];
$child_category_id2=$row_docs2['child_category_id'];
$category_id2=$row_docs2['category_id'];
?>
if($sub_category_id!='0' and $child_category_id!='0')
{
?>
$query_sc = "SELECT * from tbl_sub_category where sub_category_id='".$sub_category_id2."' and category_id='".$row['category_id']."' and sub_category_status='1'";
$result_sc = mysqli_query($con, $query_sc);
while($row_sc = mysqli_fetch_assoc($result_sc))
{
$sub_id=$row_sc['sub_category_id'];
?>
$a=40;
$query_cc = "SELECT * from tbl_child_category where sub_category_id='".$sub_id."' and category_id='".$row['category_id']."' and child_category_status='1'";
$result_cc = mysqli_query($con, $query_cc);
while($row_cc = mysqli_fetch_assoc($result_cc))
{
$child_id=$row_cc['child_category_id'];
?>
$m=40;
?>
$query_docs1 = "SELECT * from tbl_docs where sub_category_id='".$sub_id."' and child_category_id='".$child_id."' and docs_status='1'";
$result_docs1 = mysqli_query($con, $query_docs1);
while($row_docs1 = mysqli_fetch_assoc($result_docs1))
{
?>
if($row_docs1['docs_url']=="")
{
?>