public static function deleteSkillPlan($skillplan_id, $groupID)
{
global $db;
$stmt = $db->prepare('SELECT * FROM skillplan_subgroups WHERE skillplan_id = ? AND gid = ?');
$stmt->execute(array($skillplan_id, $groupID));
$subgroupList = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($subgroupList as $subgroup) {
Skillplan::deleteSubGroup($subgroup['subgroup_id']);
}
$stmt = $db->prepare('DELETE FROM skillplan_main WHERE skillplan_id = ? AND gid = ?');
$stmt->execute(array($skillplan_id, $groupID));
}
