0 and p.id=r.page_id and p.status='Yes' and r.user_id=".$user_id." order by p.ordering,p.feature_id,p.id "; $subquery=db_query($subsql); while($submenu=mysqli_fetch_object($subquery)) { if($sb_count[$submenu->feature_id]==0) {$sb_count[$submenu->feature_id] = 1;} else {$sb_count[$submenu->feature_id] = $sb_count[$submenu->feature_id] + 1;} $sb_id[$submenu->feature_id][$sb_count[$submenu->feature_id]] = $submenu->id; $sb_folder[$submenu->feature_id][$sb_count[$submenu->feature_id]] = $submenu->folder_name; $sb_link[$submenu->feature_id][$sb_count[$submenu->feature_id]] = $submenu->page_link; $sb_name[$submenu->feature_id][$sb_count[$submenu->feature_id]] = $submenu->page_name; $sb_title[$submenu->feature_id][$sb_count[$submenu->feature_id]] = $submenu->page_title; } $sql="select distinct f.id, f.feature_name, f.icon,f.ordering from user_feature_manage f, user_roll_activity r, user_page_manage p where r.access>0 and p.id=r.page_id and p.feature_id=f.id and r.user_id=".$user_id." and f.module_id=".$mod_id." and f.status='yes' order by f.ordering,f.id"; $query=db_query($sql); $count = mysqli_num_rows($query); if($count>0) { $m = 1; while($menu = mysqli_fetch_object($query)) { if($m==4) {$m=1;} else {$m++;} echo '';} } } ?>