Saturday, December 17, 2005

Subform in php

The last two weeks I have translated a small Access database for a music association to the Internet using php and mysql.

One new challenge was how to get a subform over. It looks like this in Access:



This is what I came up with in the browser:


Three queries was needed. One to display the fee records for each year, another to display the years in the combo for the chosen member, and a third to give the content of the fields for the chosen year.

I liked the solution.

No comments: