Error when use the aritmatic command * and + in $this->datatabel->select( );

[Daiku88]

i got error when use igniter in select array when use * and + aritmatik sql

this the code :

function json() {
$this->datatables->select('tj.tj_qty1 * tj.tj_harga1+tj.tj_qty2*tj.tj_harga2+tj.tj_qty3 * tj.tj_harga3 + tj.tj_qty4 * tj.tj_harga4 as total');
$this->datatables->from('tj_detail tj');
$nol = array('0');
$this->datatables->where('tj.status',$nol);
return $this->datatables->generate();

[FayazK]

I think this could help
$this->datatables->select('(tj.tj_qty1 * tj.tj_harga1+tj.tj_qty2*tj.tj_harga2+tj.tj_qty3 * tj.tj_harga3 + tj.tj_qty4 * tj.tj_harga4) as total');

[send2dawood]

Replace the query bellow with this one .
$this->datatables->select('tj.tj_qty1 * tj.tj_harga1+tj.tj_qty2*tj.tj_harga2+tj.tj_qty3 * tj.tj_harga3 + tj.tj_qty4 * tj.tj_harga4 as total',FALSE);
$this->datatables->from('tj_detail tj');
$nol = array('0');
$this->datatables->where('tj.status',$nol);
return $this->datatables->generate();

YOUR QUERY
$this->datatables->select('tj.tj_qty1 * tj.tj_harga1+tj.tj_qty2*tj.tj_harga2+tj.tj_qty3 * tj.tj_harga3 + tj.tj_qty4 * tj.tj_harga4 as total');
$this->datatables->from('tj_detail tj');
$nol = array('0');
$this->datatables->where('tj.status',$nol);
return $this->datatables->generate();