function get_all_tax_types_simple()
{
- $sql = "SELECT * FROM ".TB_PREF."tax_types";
+ $sql = "SELECT * FROM ".TB_PREF."tax_types WHERE !inactive";
return db_query($sql, "could not get all tax types");
}
db_query($sql, "could not delete tax type");
// also delete any item tax exemptions associated with this type
- $sql = "DELETE FROM ".TB_PREF."item_tax_type_exemptions WHERE tax_type_id=$type_id";
+ $sql = "DELETE FROM ".TB_PREF."item_tax_type_exemptions WHERE tax_type_id=".db_escape($type_id);
db_query($sql, "could not delete item tax type exemptions");
}
-?>
\ No newline at end of file