function add_account_type($id, $name, $class_id, $parent)
{
$sql = "INSERT INTO ".TB_PREF."chart_types (id, name, class_id, parent)
- VALUES ($id, ".db_escape($name).", ".db_escape($class_id).", ".db_escape($parent).")";
+ VALUES (".db_escape($id).", ".db_escape($name).", ".db_escape($class_id).", ".db_escape($parent).")";
return db_query($sql);
}
$sql = "SELECT * FROM ".TB_PREF."chart_types";
if (!$all) $sql .= " WHERE !inactive";
- $sql .= " ORDER BY class_id, id";
+ $sql .= " ORDER BY class_id, id, parent";
return db_query($sql, "could not get account types");
}
{
$sql = "SELECT * FROM ".TB_PREF."chart_class";
if (!$all) $sql .= " WHERE !inactive";
- $sql .= " ORDER BY cid";
+ $sql .= " ORDER BY ctype, cid";
return db_query($sql, "could not get account types");
}