Create("churchil_demo"); if ($delete) { echo("
\n"); while ($id = current($delete)) { $name = $sql->QueryItem("select Name from ACME_Locations where ID = $id"); $sql->Delete("delete from ACME_Locations where ID = $id"); echo("

Removed $name

\n"); next($delete); } echo("
\n"); } ?>
Delete Locations
Query("select ID,Name from ACME_Locations order by Name"); for ($i = 0; $i < $sql->rows; $i++) { $sql->Fetch($i); $ID = $sql->data[ID]; $Name = $sql->data[Name]; echo("\n"); echo(" \n"); } if ($sql->rows == 0) { echo("\n"); } ?>
$Name
No Locations currently listed in the database

Note, the system will not let you delete a location which is being used in a current seminar. You will need to edit the seminar and select a different locaiton first.