<?
    require("util.php3");
    DoTitle("ACME Party Balloons - Delete Seminars");
    $sql = new MySQL_class;
    $sql->Create("churchil_demo");

    if ($delete) {
        echo("<font color=blue><center>\n");
        while ($id = current($delete)) {
            $sql->QueryRow("select ACME_Seminars.Time, ACME_Locations.City, ACME_Locations.State from ACME_Seminars, ACME_Locations where ACME_Seminars.Location = ACME_Locations.ID and ACME_Seminars.id = $id");
            $date = $sql->data[0];
            $city = $sql->data[1];
            $state = $sql->data[2];
            $sql->Delete("delete from ACME_Seminars where ID = $id");
            echo("<h4>Removed $date in $city, $state</h4>\n");
            next($delete);
        }
        echo("</font></center>\n");
    }
?>

<form method="post">
<center>
<table border=1 cellpadding=5>
<tr><th bgcolor="#ffaaaa">Delete Seminars</th></tr>
<tr><td>
<table cellpadding=2>
<?
    $sql->Query("select ACME_Seminars.ID, ACME_Seminars.Time, ACME_Locations.City, ACME_Locations.State from ACME_Seminars, ACME_Locations where ACME_Seminars.Location = ACME_Locations.ID order by Time");
    for ($i = 0; $i < $sql->rows; $i++) {
        $sql->Fetch($i);
        $ID = $sql->data[0];
        $date = $sql->data[1];
        $City = $sql->data[2];
        $State = $sql->data[3];
        echo("<tr><td><input type=checkbox name=\"delete[]\" value=$ID></td>\n");
        echo("    <td>$date in $City, $State</td></tr>\n");
    }
    if ($sql->rows == 0) {
        echo("<tr><td>No Seminars currently listed in the database</td></tr>\n");
    }
?>
</table>
</td></tr>
<tr><td align=center>
<input type=submit value="Delete Seminars">
<input type=reset value="Reset Form">
</td></tr>
</table>
</center>
</form>
<?
    include("footer.php3");
?>
