Hi,

Is it possible to generate the following report using SQL or php? Any sample programs or instructions are greatly appreciated.

Suppose there is a database with 2 tables, Student and Course, with a many-to-many relationship. The report:

[Firstname] [Lastname] has taken the following course:
[course title 1]
[course title 2]
……

[Firstname] [Lastname] has taken the following course:
[course title 1]
[course title 2]
……

In particular, I want to have the text “has taken the following course:” in the output.

Many thanks,
Libo