$sector_array=array();
$category_array=array();
$category_det_array=array();
$sector_menu='';
$cat_menu ='';
$category_det='';
$sector_qry=mysqli_query($con, "SELECT * FROM tbl_sector ORDER BY liorder");
while($sector_fch =mysqli_fetch_array($sector_qry)){
$sector_array[]=$sector_fch;
$sector_name= $sector_fch['sector'];
$sector_menu = $sector_menu.'
foreach($sector_array as $sector){
$category_menu='';
$category_details_menu='';
$cat= array();
$sec_catId='';
$sec_catId = $sector['cat_id'];
$catqry = mysqli_query($con, "select * from tbl_faq_category where sectorid='$sec_catId' order by liorder;");
while($catfet= mysqli_fetch_array($catqry)){
$cat[]=$catfet;
}
//echo "
";
//print_r($cat);
foreach($cat as $cater){
$catdet=array();
$catdet[]='';
$cat_sectorId = $cater['cat_id'];
$category_name = $cater['categoryname'];// echo $category_name;
$category_menu = $category_menu.'
'.$category_name.'';
//echo $category_menu;
//$category_details_menu='';
$category_details_menu =$category_details_menu.'
';
$cat_details_qry = mysqli_query($con, "SELECT * FROM tblfaqdet WHERE category = '$cat_sectorId' order by liorder;");
//echo "SELECT * FROM tblfaqdet WHERE category = '$cat_sectorId' order by liorder;";
///my custom code
if ($cat_details_qry) {
// Iterate through the result set and display the records
while ($catdetail = mysqli_fetch_assoc($cat_details_qry)) {
$faq_name = $catdetail['faqname']; // Adjust the index based on the actual structure
$faq_description = $catdetail['description'];
$category_details_menu .= '
' . $faq_name . '
' . '
' . $faq_description . '
';
}
} else {
// Handle the case where the query was not successful
echo "Error executing query: " . mysqli_error($con);
}
$category_details_menu =$category_details_menu.'
';
//echo $category_details_menu; echo "";
//die;
}
//echo $category_details_menu;
?>
echo $category_details_menu ?>
} ?>