File: /home/awaldron/www/archive/demo/eventreg_is_list.php
<?php
session_start();
?>
<html>
<head>
<title>Attendee List</title>
</head>
<link rel="stylesheet" type="text/css" href="default.css">
<?php
include("_functions.php");
dbconnect();
$sql = "SELECT * FROM tbl_event as A, tbl_event_is as B WHERE B.event_id=A.event_id and B.eis_id=".$_GET["sid"];
$result = mysql_query($sql);
extract(mysql_fetch_array($result));
if ($event_word == 1) {
$word = "class";
$maxnum = "Seats";
} else if ($event_word == 2) {
$word = "event";
$maxnum = "Max # Participants";
}
if (isset($_GET["delete"])) {
$sql = "DELETE FROM tbl_event_is_att WHERE isatt_id=".$_GET["delete"]." LIMIT 1";
$result = mysql_query($sql);
if ($result) echo notice("Attendee removed successfully");
else echo error("There was an error when attempting to make the change.");
echo "<body style=\"margin:15px;font-size:12px;\" onLoad=\"window.opener.location='/eventreg_is.php?id=".$event_id."';this.close();\">\n";
}
echo "<body style=\"margin:15px;font-size:12px;\">\n";
echo "<P><span class=\"subhead\">".$eis_title."</span>\n";
echo "<br><b>No Dates Scheduled</b>\n";
echo "<P>If you wish to <b style=\"color:#DD0000;\">cancel</b> your registration for this ".$word.", click the <a href=\"#\">remove</a> link next to your name.\n";
$sql = "SELECT * FROM tbl_event_is_att WHERE eis_id=".$_GET["sid"]." ORDER BY attendee ASC";
$result = mysql_query($sql);
echo "<P><b>Attendees:</b>\n<ol>\n";
for ($i=0; $k = mysql_fetch_array($result); $i++) {
echo "<li> ".$k["attendee"];
if ($k["registrant"] == $_SESSION["auth_user"]) echo " (<a href=\"eventreg_is_list.php?delete=".$k["isatt_id"]."&sid=".$k["eis_id"]."\">remove</a>)\n";
}
echo "</ul>\n";
?>