How to get moodle module name from module id

I want to list the names of the modules (activities) in my course sections from moodle function or from db query. I can get section details and module id from `mdl_course_sections` and `mdl_course_modules` tables I want to get name or tile put in every activity to be list down. I already tried `mod_frog_get_coursemodule_info($cm)` but I hadn't any luck with it.