Here is my code
$query= mysql_query("SELECT course_code,COUNT(*) FROM tally GROUP BY course_code;");
I have tested this line first on my XAMPP SQL
SELECT course_code,COUNT(*) FROM tally GROUP BY course_code
and it ouputs the data I want but when it comes to PHP query
I have no idea how to fetch the query and display it
the aim was to display all the course name and its count