prepare("SELECT * FROM support_tickets WHERE id = ? AND user_id = ?"); $stmt->bind_param("ii", $ticket_id, $user_id); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) { $ticket = $result->fetch_assoc(); } else { // Ticket not found or doesn't belong to the user header('Location: tickets.php?error=not_found'); exit(); } $stmt->close(); // Fetch all replies for this ticket, joining with users to get the replier's name $stmt_replies = $conn->prepare(" SELECT tr.*, u.username 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 #

Posted on

Replied on

Add a Reply