Another option if want to use php to generate the reports is to write a pdf file.
FPDF is free and easy to use. The site has samples.
You could also consider a reporting package like Crystal which would connect directly to your mysql db to create reports.