hey guys I have question about mdl_course_modules that what does contain??
And If i run this query what does it gives me modules for courses,
But what is the meaning of modules of courses???
SELECT c.shortname,m.id,m.course,m.module,m.instance FROM `mdl_course_modules` as m
join mdl_course as c on c.id=m.course
When you display a course page, all the activities and resources on that page are 'course modules' and live in that table. Amongst other things it points to the module type (mdl_module table) to say what sort of activity/resource it is and the instance tells you which entry to look at within the table (e.g. mdl_forum) for that module type.
Thanks for your free support!!
And this is my new query that gives which activities or resources are in your course with name!!!
Name is from mdl_modules table!!
