main menu, m=>sub-menu, s=>sub-sub-menu, l=>left menu, f=>footer menu(Under More Details)
$sql1=mysqli_query($dbconn, "select * from tblmenu where status=1 and p_rewrite_url='news-and-media' and (menu_type='t' or menu_type='m' or menu_type='s')");
$pagerow=mysqli_num_rows($sql1);
if($pagerow<=0){
$sql1=mysqli_query($dbconn, "select * from tblmenu where status=1 and p_rewrite_url='$ews-and-media' and (menu_type='f' or menu_type='l')");
$pagerow=mysqli_num_rows($sql1);
if($pagerow<=0){
//redirect(SITE_URL);
}
}
$ds1=mysqli_fetch_array($sql1);
$sql="select *,year(date) as 'year' from tblnews_media where status=1 and link='$req_url'";
$newssql=mysqli_query($dbconn, $sql);
$ds=mysqli_fetch_array($newssql);
$gbl_title=($ds['meta_title']!=""?$ds['meta_title']:$ds['title']);
$gbl_description=($ds['meta_desc']!=""?$ds['meta_desc']:$ds['short_description']);
$gbl_keywords=($ds['meta_keywords']!=""?$ds['meta_keywords']:$gbl_keywords);
$gbl_newsimage=SITE_URL."data/news-media/".$ds['image'];
$b_crumb=' » '.$ds1['name'];
$page_type=$ds1['menu_type'];
/*$child_count=0;
if($page_type=='t' || $page_type=='f'){
$b_crumb=' » '.$ds1['name'];
if($page_type=='t'){
$child_qry=mysqli_query($dbconn, "select * from tblmenu where status=1 and menuid='".$ds1['id']."' and menu_type='m' order by seq_no");
$child_count=mysqli_num_rows($child_qry);
}
}
elseif($page_type=='m'){
$menu_row=mysqli_fetch_array(mysqli_query($dbconn, "select * from tblmenu where status=1 and id='".$ds1['menuid']."' and menu_type='t'"));
if(!empty($menu_row['p_rewrite_url'])){ $menulink=$menu_row['p_rewrite_url'].'.html';}else{ $menulink='javascript:void(0)';}
$b_crumb=' » '.$menu_row['name'].''.' » '.$ds1['name'];
$parent_row=mysqli_fetch_array(mysqli_query($dbconn, "select * from tblmenu where status=1 and id='".$ds1['menuid']."' and menu_type='t'"));
$child_qry=mysqli_query($dbconn, "select * from tblmenu where status=1 and menuid='".$ds1['menuid']."' and menu_type='m' order by seq_no");
$child_count=1;
}
elseif($page_type=='s'){
$submenu_row=mysqli_fetch_array(mysqli_query($dbconn, "select * from tblmenu where status=1 and id='".$ds1['menuid']."' and menu_type='m'"));
$menu_row=mysqli_fetch_array(mysqli_query($dbconn, "select * from tblmenu where status=1 and id='".$submenu_row['menuid']."' and menu_type='t'"));
if(!empty($menu_row['p_rewrite_url'])){ $menulink=$menu_row['p_rewrite_url'].'.html';}else{ $menulink='javascript:void(0)';}
if(!empty($submenu_row['p_rewrite_url'])){ $submenulink=$submenu_row['p_rewrite_url'].'.html';}else{ $submenulink='javascript:void(0)';}
$b_crumb=' » '.$menu_row['name'].''.' » '.''.$submenu_row['name'].''.' » '.$ds1['name'];
$parent_row1=mysqli_fetch_array(mysqli_query($dbconn, "select * from tblmenu where status=1 and id='".$ds1['menuid']."' and menu_type='m' order by seq_no"));
$child_qry=mysqli_query($dbconn, "select * from tblmenu where status=1 and menuid='".$parent_row1['menuid']."' and menu_type='m' order by seq_no");
$parent_row=mysqli_fetch_array(mysqli_query($dbconn, "select * from tblmenu where status=1 and id='".$parent_row1['menuid']."' and menu_type='t'"));
$child_count=1;
}*/
$navigation_page_url=$ds1['p_rewrite_url'].'.html';
$menuname="";$clsselected="";
$clsselected="selected";
$menuname=ucwords($ds1['name']);
$menu_id=$ds1['id'];
/*if($page_type=='t'){
$url_insubmenu=mysqli_num_rows(mysqli_query($dbconn, "select id from tblmenu where status=1 and p_rewrite_url='news-and-media' and menu_type='m' "));
if($url_insubmenu<=0){
$clsselected="selected";
$navigation_page_url=$ds1['p_rewrite_url'].'.html';
}
$menuname=ucwords($ds1['name']);
$menu_id=$ds1['id'];
}elseif($page_type=='m' || $page_type=='s'){
$menuname=ucwords($parent_row['name']);
$menu_id=$parent_row['id'];
$navigation_page_url=$parent_row['p_rewrite_url'].'.html';
}
$leftmenu_qry=mysqli_query($dbconn, "select * from tblmenu where status=1 and menu_type='l' and menuid='$menu_id'");
$leftmenu_count=mysqli_num_rows($leftmenu_qry);*/
include "header.php";?>
*/?>