/**
* Edit a certain expense
*/
public static function editExpense($id, $name, $cost, $type)
{
if ($name == '' || $cost == '') {
self::$lasterror = 'Name and cost must be entered';
return false;
}
$name = DB::escape($name);
$cost = DB::escape($cost);
$type = strtoupper($type);
if ($type == '') {
$type = 'M';
}
// Default as monthly
$sql = 'UPDATE ' . TABLE_PREFIX . "expenses\n\t\t\t\t\tSET `name`='{$name}', `cost`='{$cost}', `type`='{$type}'\n\t\t\t\t\tWHERE `id`={$id}";
DB::query($sql);
if (DB::errno() != 0) {
return false;
}
return true;
}
