prepare("SELECT st.*, u.username FROM support_tickets st JOIN users u ON st.user_id = u.id WHERE st.id = ?"); $stmt->bind_param("i", $ticket_id); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) { $ticket = $result->fetch_assoc(); } else { header('Location: tickets.php?error=not_found'); exit(); } $stmt->close(); // Fetch all replies, joining with users to get the replier's name $stmt_replies = $conn->prepare("SELECT tr.*, u.username, u.role FROM ticket_replies tr JOIN users u ON tr.user_id = u.id WHERE tr.ticket_id = ? ORDER BY tr.created_at ASC"); $stmt_replies->bind_param("i", $ticket_id); $stmt_replies->execute(); $replies_result = $stmt_replies->get_result(); if ($replies_result) { $replies = $replies_result->fetch_all(MYSQLI_ASSOC); } $stmt_replies->close(); ?>

Ticket #

Subject: | From:

Posted on

Replied on

Post a Reply