query("SELECT COUNT(id) AS total FROM rtxreport $searchQuery");
$rownew = $result->fetchArray();
$totaleview = $rownew['total'];
$total_pages = ceil($rownew['total'] / $results_per_page);
$res1 = $db1->query("SELECT * FROM rtxreport $searchQuery ORDER BY id ASC LIMIT $start_from, $results_per_page");
if (isset($_GET['delete'])) {
$db1->exec('DELETE FROM rtxreport WHERE id=' . $_GET['delete']);
header('Location: report.php');
}
include 'includes/header.php';
?>