Using the sakila sample database, I've created a handful of reports that I thought would be interesting and useful. The report name, description, and the SQL to create it are stored in the database and the links to those reports are listed to the right of this page. Each report calls a single program, show_sakila_report.php, which takes the report name as a parameter. The program displays the report name, description, and SQL. Then it runs the SQL to create the report processing the results as a table with the column names as headings.

This is part of my idea to create dynamic web content using MySQL and php. This is a work in progress, so if a link does nothing, I'm still working on it!