Need help on converting mysql query to codeigniter active record

Code:

SELECT date(`timestamp`)
     , COUNT(`odr_id`) AS num_sales
     , SUM(`amnt_paid`) AS daily_total
     , SUM(gov_fee) as e_pay
     , SUM(items_total) as sum_tot_cost
  FROM item_table
GROUP
    BY date(`timestamp`)
where ('user', $this->session->userdata('usernm'));

I get the username as table column and throws error saying "column not found"

@jollytsr,

Have you tried running this query directly in MySQL and seeing if it works correctly?

@jollytsr,

Have you tried running this query directly in MySQL and seeing if it works correctly?

@php_rocs

Thanks for your kind reply.

I have tried in mysql. It works perfectly. But unable to use it in codeIgniter.

@ jollytsr,

Can we see the code how you have it exactly in CI (line for line)?

@ jollytsr,

Can we see the code how you have it exactly in CI (line for line)?

Hello, send the way you set up the query using codeigniter(https://www.codeigniter.com/userguide3/d...ilder.html).