prepare("
SELECT p.*, GROUP_CONCAT(t.name) AS tags
FROM posts p
LEFT JOIN post_tags pt ON p.id = pt.post_id
LEFT JOIN tags t ON pt.tag_id = t.id
WHERE p.id = ?
GROUP BY p.id
");
$stmt->execute([$post_id]);
$post = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$post) {
die("Post not found.");
}
// Convert tags to comma list
$tagList = $post['tags'] ? implode(", ", explode(",", $post['tags'])) : "";
?>
Edit Post