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