deansaddigh Posted August 18, 2010 Share Posted August 18, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/211079-want-to-get-how-many-records-in-a-particular-part-of-sql-query/ Share on other sites More sharing options...
fenway Posted August 18, 2010 Share Posted August 18, 2010 I suppose you can do this inline with a subquery Quote Link to comment https://forums.phpfreaks.com/topic/211079-want-to-get-how-many-records-in-a-particular-part-of-sql-query/#findComment-1100988 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.