MySQL

Putting DBI To Work

At this point you've seen a number of the concepts involved in DBI programming, so let's move on to some of the things we wanted to be able to do with our sample database. Our goals were outlined initially in Chapter 1, "Introduction to MySQL and SQL." Those that we'll tackle by writing DBI scripts in this chapter are listed here.

For the grade-keeping project, we want to be able to retrieve scores for any given quiz or test.

For the historical league, we want to do the following:

• Produce the member directory in different formats. We want a names-only list for use in the annual banquet program in a format we can use for generating the printed directory.

• Find League members that need to renew their memberships soon, then send ...