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

[eluser]maria clara[/eluser]
i commented for a while the $data['client_id']
Code:
$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 now it doesn't show the error. i still figuring out where can that be placed??


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