function retreiveAttendanceMemberValues($meeting) { $meeting_type = retreiveMeetingTypeForMeeting($meeting); $query = "SELECT `member`, `name` FROM v_member_dd WHERE member NOT IN (SELECT `member` FROM attendance WHERE `meeting` = " . $meeting . ") AND `meeting_type` = " . $meeting_type . ";"; $result = mysql_query($query); $val = array(); while ($row = mysql_fetch_row($result)) { $val[$row[0]] = $row[1]; } return $val; }
function retreiveAdditionalAttendanceMemberCount($meeting) { $meeting_type = retreiveMeetingTypeForMeeting($meeting); $query = "SELECT COUNT(*) num FROM v_member_dd WHERE member NOT IN (SELECT `member` FROM attendance WHERE `meeting` = " . $meeting . ") AND `meeting_type` = " . $meeting_type . ";"; $result = mysql_query($query); $row = mysql_fetch_row($result); return $row[0]; }