want to get how many records in a particular part of sql query

[deansaddigh]

Hi guys, i want to get how many courses there are for each school.

 

heres my sql query

 

$querycourselevels = "select school_course.school_id, school_course.course_id, course.name AS coursename,course.course_id, course.level, course.info, course.min_duration, course.weekly_interval, course.price, school.school_id, school.name AS school_name
		  FROM school_course
		  JOIN course
		  ON school_course.course_id = course.course_id
		  JOIN school
		  ON school_course.school_id = school.school_id 
		  ORDER BY school_name";
		  $result = mysql_query($query, $conn)
			  or die ("error retrieving course levels");

 

i want to get how many courses are brought back for each school that they are connected to so i can dispaly a number next to each school

like this school has 8 courses etc.

 

Does anyone know how to do it please

 

Kind regards

Dean

 

[fenway]

I suppose you can do this inline with a subquery