function DeleteUnitAndItems($id)
{
StartAccessToDB();
$result = "";
// Start by deleting all the items pointing to the given unit
if (DeleteItems("Where UnitId={$id}") == "") {
$request = "DELETE FROM jh_units where Id={$id}";
$reqResult = mysql_query($request);
if (!$reqResult) {
$result = $request . "<br>" . mysql_error();
} else {
$result = "";
}
}
// then remove the unit itself
$request = "DELETE FROM jh_units where Id={$id}";
$reqResult = mysql_query($request);
if (!$reqResult) {
$result = $request . "<br>" . mysql_error();
} else {
$result = "";
}
EndAccessToDB();
return $result;
}
<?php
require_once "data_access.php";
$result = DeleteItems("WHERE Id=8");
echo $result;
