$sql = "SELECT MAX(reconciled) as last_date,
SUM(IF(reconciled<='$date', amount, 0)) as end_balance,
SUM(IF(reconciled<'$date', amount, 0)) as beg_balance,
SUM(amount) as total
FROM ".TB_PREF."bank_trans trans
$sql = "SELECT MAX(reconciled) as last_date,
SUM(IF(reconciled<='$date', amount, 0)) as end_balance,
SUM(IF(reconciled<'$date', amount, 0)) as beg_balance,
SUM(amount) as total
FROM ".TB_PREF."bank_trans trans