Question: Create a PHP webpage that lets the user select from these available reports to be run. On display of each report, the user should be

Create a PHP webpage that lets the user select from these available reports to be run. On display of each report, the user should be able to return to the main page to run another report.

-- Region Month Report: Let the user select a Region and a month/year. Show the total attendance by Chapter for each Chapter in the Region that month. (Total attendance should be the sum of columns "pr" through "others". It should not include groups 1, 2, 3.)

-- Chapter Report: Let the user select a Chapter. Show the total attendance for that Chapter each month/year available in the database.

(The Database is built from the following query)

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

create table ch_attended ( seqnum int not null primary key, region int, month int, year int, chapter char(4), pr int, vp1 int, vp2 int, tr int, atr int, se int, ase int, cm1 int, cm2 int, cm3 int, cm4 int, cm5 int, cm6 int, cm7 int, cm8 int, others int, group1 int, group2 int, group3 int );

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!