<?php
require_once 'config.php';
$db = getDB();
$cats = $db->fetchAll("SELECT id, name FROM course_categories");
echo "CATEGORIES:\n";
print_r($cats);

$courses = $db->fetchAll("SELECT id, course_name, short_name, category FROM courses ORDER BY id DESC LIMIT 10");
echo "\nCOURSES:\n";
print_r($courses);