$page = 1; //Default page $limit = 25; //Records per page $start = 0; //starts displaying records from 0 if (isset($_GET['page']) && $_GET['page'] != '') { $page = $_GET['page']; } $start = ($page - 1) * $limit; if ($_GET['limite']) { $limit = $_GET['limite']; } $users = getusers_list_temp($_REQUEST['sort'], $start, $limit); //$rows= '4273'; $rows = count(CustomersCount()); $last_element = $_GET['page']; if ($_GET['delete_id']) { $delete_id = $_GET['delete_id']; $sql = "UPDATE sohorepro_company\r\r\n\t\t\tSET status = '0',\r\r\n archive = '1' \r\r\n WHERE comp_id= '" . $delete_id . "' "; $sql_result = mysql_query($sql); if ($sql_result) { $result = "success_del"; } else { $result = "failure_del"; } } if ($_GET['delete_product_id']) { $delete_id = $_GET['delete_product_id']; $sql = "DELETE FROM sohorepro_special_pricing WHERE sp_id = " . $delete_id . " "; $sql_result = mysql_query($sql);
//Records per page $start = 0; //starts displaying records from 0 if (isset($_GET['page']) && $_GET['page'] != '') { $page = $_GET['page']; } $start = ($page - 1) * $limit; if ($_GET['limite']) { $limit = $_GET['limite']; } $users = getusers_list_temp($_REQUEST['sort'], $start, $limit); $filter_by_customer = $_GET["cus_type_fil"]; $admin_added = $_GET["admin_added"] != '' ? $_GET["admin_added"] : ''; $filtered_customer = FilterByCustomer($filter_by_customer, $admin_added, $start, $limit); //$rows= '4273'; $rows = $filter_by_customer != '' ? count(FilterByCustomerCount($filter_by_customer)) : count(CustomersCount()); $last_element = $_GET['page']; if ($_GET['delete_id']) { $delete_id = $_GET['delete_id']; /* $sql = "UPDATE sohorepro_company SET status = '0', archive = '1' WHERE comp_id= '" . $delete_id . "' "; */ $sql_user = "******" . $delete_id . "'"; mysql_query($sql_user); $sql = "DELETE FROM sohorepro_company WHERE comp_id = " . $delete_id . " "; $sql_result = mysql_query($sql); if ($sql_result) { $result = "success_del"; } else { $result = "failure_del";