1) { $where_data[""] = " `stock_user_verified` = 0 "; } $admin_verified = $_GET["admin_verified"]; if (strlen($admin_verified) > 1) { $where_data[""] = "`stock_user_verified` = 1 AND `admin_verified` = 0 "; } $approvals = $_GET["approvals"]; if (strlen($approvals) > 1) { $where_data[""] = "`stock_user_verified` = 1 AND `admin_verified` = 1 AND `approved` = 0"; } $client_id = $_GET['client_id']; if ($client_id >= 1) { $where_data[] = "client_id = " . $client_id . ""; } $quote_number = $_GET['quote_number']; if ($quote_number >= 1) { $where_data[] = "quote_number = " . $quote_number . ""; } $description = $_GET['description']; if (strlen($description) >= 1) { $where_data[] = "description LIKE '%" . $description . "%'"; } $start_date = $_GET['start_date']; if ($start_date >= 1) { $where_data[] = "date_time_created >= '" . $start_date . "'"; } $end_date = $_GET['end_date']; if ($end_date >= 1) { $where_data[] = "date_time_created <= '" . $end_date . "'"; } if (count($where_data) > 0) { $where = " WHERE " . implode(" AND ", $where_data); } else { $where = " WHERE 1"; } // echo "SELECT * FROM `stock_items` $where ORDER BY record_id DESC"; $result = $db->conn->query("SELECT * FROM `quotes` $where ORDER BY record_id DESC"); if ($result->num_rows > 0) { $index = 0; while ($data = $result->fetch_assoc()) { $client_info = $db->get_client_info($data["client_id"]); echo "
DESCRIPTION
QUOTE
DATE
CLIENT
"; $index++; } } else { echo "

NO RESULTS

"; }