Welcome Guest, Not a member yet? Register   Sign In
[solved!] A Database Error Occurred
#3

[eluser]maria clara[/eluser]
here's the function in my MODEL:
Code:
function updateCustomerBalance($data)
    {
        $this->db->select('SUM(gross) as sales, SUM(paid) as payment, SUM(credit) as credit, SUM(debit) as debit, SUM(return) as `return`');
        $this->db->where('client_id', $data['client_id']);
        $this->db->where('status !=', '2');
        $this->db->where('is_deleted', '0');
        $sales = $this->db->get('ar_sales')->row_array();
        
        $sales['balance'] = $sales['sales'] - $sales['payment'] - $sales['credit'] + $sales['debit'] - $sales['return'];
        
        $this->db->where('cust_id', $data['client_id']);
        $this->db->update('maint_customers', $sales);
    }


and also im having this error
Code:
<p>Message:  Undefined index:  client_id</p>
<p>Filename: models/ccm_receipt_db.php</p>
<p>Line Number: 292</p>

and this points to the database error i encountered


Messages In This Thread
[solved!] A Database Error Occurred - by El Forum - 01-11-2010, 08:08 PM
[solved!] A Database Error Occurred - by El Forum - 01-11-2010, 08:20 PM
[solved!] A Database Error Occurred - by El Forum - 01-11-2010, 08:54 PM
[solved!] A Database Error Occurred - by El Forum - 01-11-2010, 09:18 PM
[solved!] A Database Error Occurred - by El Forum - 01-11-2010, 09:29 PM
[solved!] A Database Error Occurred - by El Forum - 01-11-2010, 09:45 PM
[solved!] A Database Error Occurred - by El Forum - 01-11-2010, 09:46 PM
[solved!] A Database Error Occurred - by El Forum - 01-11-2010, 09:55 PM
[solved!] A Database Error Occurred - by El Forum - 01-11-2010, 09:57 PM
[solved!] A Database Error Occurred - by El Forum - 01-11-2010, 09:58 PM



Theme © iAndrew 2016 - Forum software by © MyBB