Create("churchil_demo"); if ($DelCat) { # Ok, the user has selected something to delete. Since what # was passed in was the ID value of the catagory, snag it's # name first and then delete the item. echo("

\n"); $id = current($DelCat); do { $name = $sql->QueryItem("select Name from CatagoryList where ID = $id"); $sql->Delete("delete from CatagoryList where ID = $id"); $sql->Delete("delete from Catagories where ID = $id"); echo("
Deleted Catagory: $name\n"); } while ($id = next($DelCat)); echo("

\n"); } ?>

Delete Catagory

Chose Catagory to Delete:
Note, You cannot delete catagories which have Auctions currently listed under them.
Query("select ID, Name, Num from CatagoryList order by Name"); for ($i = 0; $i < $sql->rows; $i++) { $sql->Fetch($i); $id = $sql->data[ID]; $name = $sql->data[Name]; $num = $sql->data[Num]; if ($num > 0) { echo("\n"); } else { echo("\n"); } echo(" \n"); } ?>

Catagory # Auctions

$name $num

\n"); $id = current($DelCat); do { $name = $sql->QueryItem("select Name from CatagoryList where ID = $id"); $sql->Delete("delete from CatagoryList where ID = $id"); $sql->Delete("delete from Catagories where ID = $id"); echo("Deleted Catagory: $name\n"); } while ($id = next($DelCat)); echo("

\n"); $id = current($DelCat); do { $name = $sql->QueryItem("select Name from CatagoryList where ID = $id"); $sql->Delete("delete from CatagoryList where ID = $id"); $sql->Delete("delete from Catagories where ID = $id"); echo("
Deleted Catagory: $name\n"); } while ($id = next($DelCat)); echo("