Witam Proszę o pomoc - w poniższej funkcji potrzebuję wstawić warunek gdzie: WHERE cash.customerid = ? AND cash.time <= aktualna data(UNIX) function GetCustomerBalanceListUserpanel($id, $totime = NULL, $direction = 'ASC') { ($direction == 'ASC' || $direction == 'asc') ? $direction == 'ASC' : $direction == 'DESC'; $saldolist = array(); if ($tslist = $this->DB->GetAll('SELECT cash.id AS id, time, cash.type AS type, cash.value AS value, taxes.label AS tax, cash.customerid AS customerid, comment, docid, users.name AS username, documents.type AS doctype, documents.closed AS closed , documents.number AS docnumber, documents.cdate AS docdate, numberplans.template AS doctemplate, documents.extnumber AS docextnumber, documents.fullnumber, documents.paytime FROM cash LEFT JOIN users ON users.id = cash.userid LEFT JOIN documents ON documents.id = docid LEFT JOIN taxes ON cash.taxid = taxes.id LEFT JOIN numberplans ON (numberplans.id = documents.numberplanid) WHERE cash.customerid = ? AND cash.time <= ' . ($totime ? ' AND time <= ' . intval($totime) : '') . ' ORDER BY time ' . $direction, array($id))) { $saldolist['balance'] = 0; $saldolist['total'] = 0; $i = 0; foreach ($tslist as $row) { // old format wrapper foreach ($row as $column => $value) $saldolist[$column][$i] = $value; $saldolist['after'][$i] = round($saldolist['balance'] + $row['value'], 2); $saldolist['balance'] += $row['value']; $saldolist['date'][$i] = date('Y/m/d', $row['time']); $saldolist['pdate'][$i] = $row['time'] + ($row['paytime'] * 86400); $i++; } $saldolist['total'] = sizeof($tslist); } $saldolist['customerid'] = $id; return $saldolist; } .................. pozdrawiam MB