prepare("UPDATE faqs SET question=?, answer=?, sort_order=? WHERE id=?"); $stmt->execute([$question, $answer, $order, $_POST['faq_id']]); $msg = "FAQ updated successfully!"; } else { // Insert $stmt = $pdo->prepare("INSERT INTO faqs (question, answer, sort_order) VALUES (?, ?, ?)"); $stmt->execute([$question, $answer, $order]); $msg = "FAQ added successfully!"; } $msgClass = "success"; } // 2. DELETE FAQ if (isset($_GET['delete'])) { $pdo->prepare("DELETE FROM faqs WHERE id=?")->execute([$_GET['delete']]); header("Location: faqs.php?msg=deleted"); exit(); } // 3. FETCH $edit_faq = null; if (isset($_GET['edit'])) { $stmt = $pdo->prepare("SELECT * FROM faqs WHERE id=?"); $stmt->execute([$_GET['edit']]); $edit_faq = $stmt->fetch(); } $faqs = $pdo->query("SELECT * FROM faqs ORDER BY sort_order ASC")->fetchAll(); ?> Manage FAQs

FAQ Manager

Order: