Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Thursday, March 28, 2024
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  Do I need a temporary table to do this?

phpMyEdit General     Do I need a temporary table to do this?
Post new topic   Reply to topic    
 
foxylady337     Joined: 24 Jul 2008   Posts: 10  
Post Posted: 2008-08-03 10:09
Back to top  Reply with quote     

I want to help the attendance officer of my club collect and analyse attendance statistics of members.

tbl_members holds members' details.
tbl_calendar holds details of club meetings.
I propose a new table (tbl_attendance), which will have the following fields:

attendance_key (unique key for this table)
meeting_key (refers to the meeting in the calendar)
member_key (the member whose attendance is being logged)
attendance (an enumeration, 'absent', 'present', 'credit', 'unknown')

It's simple enough to generate a PME script to edit tbl_attendance, with pull-downs to select the member and the meeting date, and radio-buttons for the attendance details, but this will be very laborious when it comes to editing the attendances for a particular meeting.

What is required is a column of names of members eligible to be at a particular meeting (already joined and not yet left at that date) and a column of radio-buttons to indicate each member's attendance. "Credit" for attendance may be earned for a missed meeting by various means, and may have to be put in at a later date.

I'd appreciate a steer from the group on how to approach this problem.

Many thanks!

 
Post new topic   Reply to topic    

Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy