How to get database report from MySQL or php?

Printable View

02-21-2011, 06:35 PM
wanglibo

How to get database report from MySQL or php?

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
04-11-2011, 04:59 AM
eval(BadCode)

Code:

SELECT CONCAT('<html><body><div>', Student.LastName ,',', Student.FirstName, GROUP_CONCAT('<p>',Course.course'</p>'), '</div></body></html>') as report FROM Student INNER JOIN Course ON Student.Course_Taken = Course.... wtf- you need another table for an n->m GROUP BY Student.Student_ID ORDER BY Student.LastName ASC

You need another table to show an n->m relationship, so that's the best you'll get: but I'm glad you at least know it's a many to many relationship ;p

All times are GMT -5. The time now is 06:39 AM.