where clause with order_by in codeigniter giving me issue

Hi All,

I am new in codeigniter framework, I have to add order_by in my query..

PHP Code:

$data['work']=$this->work->where('wuFk', session()->get('uId'))->get()->getResult(); 


I want to add the order_by('uName','DESC'), added like below but giving me issue, bad method execptions.

PHP Code:

$data['work']=$this->work->where('wuFk', session()->get('uId'))->order_by('uName','DESC')->get()->getResult();

Do you have any suggestion for order_by with where clause in query? 


  $data['work']=$this->work->where('wuFk', session()->get('uId'))->get()->getResult();

Showing the exact error message would make you get better support.

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

Assuming you are using CI4 and a model, issue may be here ->getResult() you should either use getResultArray() if you expect an array or getResultObject() if you expect an object

Web developer creating tools for streamers

Countdown Tools: https://obscountdown.com

Online Polls https://streampollmaster.com

It's orderBy not order_by if your using CodeIgniter 4.x.x

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

Hi All,



I want to add the order_by('uName','DESC'), added like below but giving me issue, bad method execptions.

PHP Code:

$data['work']=$this->work->where('wuFk', session()->get('uId'))->order_by('uName','DESC')->get()->getResult(); 


Hey hi, use orderBy() instead of order_by()

$data['work']=$this->work->where('wuFk', session()->get('uId'))->order_by('uName','DESC')->get()->getResult();