prepare(" SELECT c.id AS course_id, c.course_name, COUNT(r.id) AS total_ratings, AVG(r.rating) AS avg_rating FROM courses c LEFT JOIN enrollments e ON e.course_id = c.id LEFT JOIN course_ratings r ON r.enrollment_id = e.id GROUP BY c.id, c.course_name ORDER BY avg_rating DESC, c.course_name ASC "); $stmt->execute(); $courses = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { die(__('error_db_general') . $e->getMessage()); } ?>

= 0.25; $emptyStars = 5 - $fullStars - ($halfStar ? 1 : 0); ?>


		'; ?> '; ?> '; ?>	%