Mohammed Abdulla Sarhan Alkuhali
Mohammed Abdulla Sarhan Alkuhali
"Dean of Administrative and Financial Sciences coellge "
Prof. Dr. Sharaf Abdel-Haq Al-Hamdi
Prof. Dr. Sharaf Abdel-Haq Al-Hamdi
Head of the Department of Management Information Systems
Prof. Dr. Jabr Abdul-Qawi Al-Sanabani
Prof. Dr. Jabr Abdul-Qawi Al-Sanabani
Head of Business Administration Department
Prof. Dr. Abdullah Ali Ahmed Al-Qurashi
Prof. Dr. Abdullah Ali Ahmed Al-Qurashi
Head of the International Business Department
Dr. Fahmi Saeed Al-Dakkaf
Dr. Fahmi Saeed Al-Dakkaf
Head of the Banking and Financial Sciences Department
Dr.. Muhammad Muhammad Ali Al-Rahbi
Dr.. Muhammad Muhammad Ali Al-Rahbi
Responsible for the Academic Advising Unit
Dr. Fahmi Saeed Al-Dakkaf
Dr. Fahmi Saeed Al-Dakkaf
Head of Accounting Department
POST["keyword"]); $sql = "SELECT * FROM `$tbl_name` WHERE ( `name_english` LIKE '%$keyword%' OR `qualification_english` LIKE '%$keyword%' ) AND `name_english`!='' AND `status`='1' AND `active`='0' ORDER BY `order_view` ASC LIMIT 100"; $result = _Mysql_Query($sql); //echo _Mysql_Error(); // Security: do not expose DB errors } else if(isset($_GET['Sort']) && trim($_GET['Sort']) == 'search') { $WHERE = " WHERE `name_english`!='' AND `timestamp` <= " . time() . " AND `status`='1' AND `active`='0' "; $search =""; if(!isset($_POST['year']) && isset($_GET['year'])) $_POST['year'] = $_GET['year']; if(!isset($_POST['month']) && isset($_GET['month'])) $_POST['month'] = $_GET['month']; if(isset($_POST['year']) && intval($_POST['year']) > 0) { $search .=intval($_POST['year']); } if(isset($_POST['month']) && intval($_POST['month']) > 0) { $month = intval($_POST['month']); if($month <= 9) $month ='0'.$month ; if(!empty($search)) $search .='-'; $search .=$month; } if(!empty($search)) { $WHERE .= " AND FROM_UNIXTIME(`timestamp`, '%Y-%m')='$search' "; } //ECHO $WHERE; $sql = "SELECT `id`,`name_english`,`content_english`,`image`,`timestamp` FROM `$tbl_name` $WHERE ORDER BY `timestamp` DESC LIMIT 50"; $result = _Mysql_Query($sql); //echo _Mysql_Error(); } else { if (isset($_GET['college_id'])) { $result_count = _Mysql_Query("SELECT COUNT(`id`) AS My_Count FROM `$tbl_name` WHERE `name_english`!='' AND `college_id`='$college_id' AND `section_id`='2' AND `status`='1' AND `active`='0'"); } else { $result_count = _Mysql_Query("SELECT COUNT(`id`) AS My_Count FROM `$tbl_name` WHERE `section_id`!='2' AND `name_english`!='' AND `status`='1' AND `active`='0'"); } $my_row = _Mysql_Fetch_Array($result_count); $Count_Result = intval($my_row['My_Count']); if (isset($_GET['college_id'])) { $Url_Pages = "$site_url_english/staff/$college_id-page{no_page}"; $page_sub_title = stripcslashes($results_college['title_english']); $page_main_title = _web_university_staff; } else { $Url_Pages = "$site_url_english/staff/page{no_page}"; $page_sub_title = _web_about; $page_main_title = _web_university_admins; } $limit = 200; $page = 1; if(isset($targetpage_section)) $Url_Pages = $targetpage_section; if(isset($_GET['page'])) $page = intval($_GET['page']); if($page > 0) { $start = ($page - 1) * $limit; } else { $start = 0; } /* Get data. */ if (isset($_GET['college_id'])) { $sql = "SELECT * FROM `$tbl_name` WHERE `name_english`!='' AND `college_id`='$college_id' AND `section_id`='2' AND `status`='1' AND `active`='0' ORDER BY `order_view` ASC LIMIT $start, $limit"; } else { $sql = "SELECT * FROM `$tbl_name` WHERE `section_id`!='2' AND `name_english`!='' AND `status`='1' AND `active`='0' ORDER BY `order_view` ASC LIMIT $start, $limit"; } $result = _Mysql_Query($sql); } //page header $sql_header_background = _Mysql_Query("SELECT `section_id`,`image` FROM `Platform_headers` WHERE `section_id`='staff' AND `status`='1' AND `active`='0'"); $results_header_background = _Mysql_Fetch_Array ($sql_header_background); ?>