prepare("SELECT sub_category FROM sub_category WHERE sub_cat_id = ?");
$stmt->bind_param("s", $id);
$stmt->execute();
$stmt->bind_result($name);
$stmt->fetch();
return $name ?? 'Unknown';
}
if ($category_id && $sub_category) {
// Get total count
$stmt_count = $conn->prepare("SELECT COUNT(*) FROM short_questions WHERE category_id = ? AND sub_category_id = ?");
$stmt_count->bind_param("ss", $category_id, $sub_category);
$stmt_count->execute();
$stmt_count->bind_result($total);
$stmt_count->fetch();
$stmt_count->close();
// Fetch paginated questions
$stmt = $conn->prepare("
SELECT question, answer, chapter FROM short_questions
WHERE category_id = ? AND sub_category_id = ?
LIMIT ?, ?
");
$stmt->bind_param("ssii", $category_id, $sub_category, $offset, $limit);
$stmt->execute();
$questions = $stmt->get_result();
}
?>
num_rows > 0): ?>
fetch_assoc()): ?>
0): ?>
Chapter:
Q.No :
Answer:
$limit): ?>
No questions found for the selected criteria.