Create("churchil_demo");
$sql2 = new MySQL_class;
$sql2->Create("churchil_demo");
/* Delete the specified list of Auctions. Also clean up the other
* tables which list the number of Auctions occuring in each state, etc.
*/
if ($DelList) {
$id = current($DelList);
echo ("
\n");
$id = current($DelList);
do {
$sql->QueryRow("select Name, Location from Auctions where ID = $id");
$name = $sql->data[Name];
$loc = $sql->data[Location];
/* Decrement the number of auctions listed for this particular state */
$state = $sql->QueryItem("select State from Locations where ID = $loc");
$num = $sql->QueryItem("select Num from States where Abrev = '$state'");
if ($num > 0) {
/* $num should always be greater than zero before you
* hit this statement, but it's a good thing to include
* in case the count gets knocked out of whack by manual
* updates to the database.
*/
$num = $num - 1;
} else {
$num = 0;
}
$sql->Update("update States set Num = $num where Abrev = '$state'");
/* Decrement the number of auctions listed for each auction catagory */
$sql->Query("select CatID from Auction_Catagory_Xref where AuctID = $id");
for ($i = 0; $i < $sql->rows; $i++) {
$sql->Fetch($i);
$CatID = $sql->data[CatID];
$num = $sql2->QueryItem("select Num from CatagoryList where ID = $CatID");
if ($num > 0) {
/* $num should always be greater than zero before you
* hit this statement, but it's a good thing to include
* in case the count gets knocked out of whack by manual
* updates to the database.
*/
$num = $num - 1;
} else {
$num = 0;
}
$sql2->Update("update CatagoryList set Num = $num where ID = $CatID");
}
/* Delete the cross references from the Auction_Catagory_Xref table */
$sql->Delete("delete from Auction_Catagory_Xref where AuctID = $id");
/* Delete the records from the Auctions table */
$sql->Delete("delete from Auctions where ID = $id");
echo("
Deleted: $name\n");
} while ($id = next($DelList));
echo ("