0) { $p = new event_regis_pagination; $p->items($items); $p->limit(30); // Limit entries per page $p->target("admin.php?page=admin_reports"); $p->currentPage($_GET[$p->paging]); // Gets and validates the current page $p->calculate(); // Calculates what to show $p->parameterName('paging'); $p->adjacents(1); //No. of page away from the current page if(!isset($_GET['paging'])) { $p->page = 1; } else { $p->page = $_GET['paging']; } //Query for limit paging $limit = "LIMIT " . ($p->page - 1) * $p->limit . ", " . $p->limit; } else { echo "No Record Found"; }//End pagination ?>

Attendees/Payments

Select an event to view attendee details and payments

0 ) { while ($row = mysql_fetch_assoc ($result)){ $event_id = $row['id']; $event_name=$row['event_name']; $event_desc = $row['event_desc']; $event_description = $row['event_desc']; $event_identifier = $row['event_identifier']; $event_cost = $row['event_cost']; $active = $row['is_active']; $start_date = $row['start_date']; $end_date = $row['end_date']; $reg_limit=$row['reg_limit']; $sql2= "SELECT SUM(quantity) FROM " . $events_attendee_tbl . " WHERE event_id='$event_id'"; $result2 = mysql_query($sql2); while($row = mysql_fetch_array($result2)){ $number_attendees = $row['SUM(quantity)']; } if ($number_attendees == '' || $number_attendees == 0){ $number_attendees = '0'; } if ($reg_limit == "" || $reg_limit == " " || $reg_limit == "999"){ $reg_limit = "∞"; } if ($start_date <= date('Y-m-d')){ $active_event = 'EXPIRED'; } elseif ($active == "yes"){ $active_event = 'ACTIVE EVENT'; } else if ($active == "no"){ $active_event = 'NOT ACTIVE'; } ?>
Event ID Name Cost Start Date End Date Status # Attendees Export Action
Event ID Name Cost Start Date End Date Status # Attendees Export Action
/ '">Export To Excel View Attendees | Edit Event | View Event
No Record Found!
show(); // Echo out the list of paging. ?>