'A ticket with no client has no services to link.']); exit; } $linked = ticketServices($ticket_id); $sql = mysqli_query($mysqli, "SELECT service_id, service_name, service_description, service_category, service_importance FROM services WHERE service_client_id = $client_id AND service_archived_at IS NULL AND service_id NOT IN (SELECT service_id FROM service_tickets WHERE ticket_id = $ticket_id) ORDER BY FIELD(service_importance, 'High', 'Medium', 'Low'), service_name"); $candidates = []; while ($candidate = mysqli_fetch_assoc($sql)) { $candidates[] = $candidate; } ob_start(); ?>