Create("churchil_demo");
/* If we've got any data handed in via CGI, then delete
* the specified locations from the database. Do a bit
* of error checking, just in case, ya know? Make sure
* that the user isn't deleting any locations that are
* being used for currently listed auctions.
*/
if ($DelLoc) {
echo ("
\n");
$id = current($DelLoc);
do {
$name = $sql->QueryItem("select Name from Locations where ID = $id");
/* Before deleteing this item, make sure that no current
* Auctions are depending on it for Directions, etc.
*/
$sql->Query("select ID from Auctions where Location = $id");
if ($sql->rows != 0) {
echo("\n");
echo("
Unable to delete Location: $name. $num listed Auctions depend on it.\n");
echo("
\n");
} else {
$sql->Delete("delete from Locations where ID = $id");
echo("
Deleted: $name\n");
}
} while ($id = next($DelLoc));
echo ("