Lesson

Hi,

I've been attempting to create a mysql query which will show the following information from 2 tables.

I'm searching for strings contained within the mdl_lesson_pages 'contents' field and outputting which lessons these strings are located & the page within each lesson where the strings are located.

So I want to display when search for particular strings the following info:-

The onpage lesson id (when moused over from the main course page).
The lessonpage id (when inside a lesson)
The lesson title (of the lesson)
The previous page id (when inside a lesson)
The next page id (when inside a lesson)

Tables & Fields

The mdl_lesson_pages (id),
mdl_course_module (instance),
mdl_lesson_pages (lessonid),
mdl_lesson_pages (title),
mdl_course_module (course),
mdl_course_module (prevpageid),
mdl_course_module (nextpageid)

So far I have I can only get this to display all information except for the ID of the mdl_lesson_pages table. This is due to the fact id are both used in the two tables and I need to output the mdl_lesson_pages id and not the mdl_course_modules id but I can't.

So far I have this command :

this outputs the following :

But as you can see this doesn't output the ID from the mdl_lesson_pages table.

I can't quite work out how to output the ID field (from either table as they are ambiguous)

I was hoping some kind sole would help me out here, this is driving me barmy! I have hundreds of pages where I need to locate certain strings, to do this manually is a knightmare with the lesson module as the ID's don't corresponde.

The lessonid & instance are the matching fields from the two tables.

Much appreciated for any assistance!!

P.S. Why the lesson module built this way I will never know, doesn't make much sense to me...

Steve