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;