Codeigniter this- db- order by desc result is not complete

Question

I want to sort my database values in descending order using this query below in my model  However  it doesn t completely sort in descending order all the values in the database but when ascending is used  it works well    function sort all courses desc  tennant id         this- gt db- gt select            this- gt db- gt where  tennant id   tennant id        this- gt db- gt order by  course name   desc         this- gt db- gt from  courses         query  this- gt db- gt get        return  query- gt result

User · Answer

Put the line  this- gt db- gt order by  course name   desc    at top of your query  Like   this- gt db- gt order by  course name   desc    this- gt db- gt select        this- gt db- gt where  tennant id   tennant id    this- gt db- gt from  courses     query  this- gt db- gt get    return  query- gt result

User · Answer

this- gt db1- gt where  tennant id    tennant id    this- gt db1- gt order by  id    DESC    return  this- gt db1- gt get  courses  - gt result

User · Answer

Put from before where  and order by on last    this- gt db- gt select        this- gt db- gt from  courses     this- gt db- gt where  tennant id   tennant id    this- gt db- gt order by  UPPER course name    desc      Or try BINARY   ORDER BY BINARY course name DESC    You should add manually on codeigniter for binary sorting   And set  course name  character column      If sorting is used on a character type column  normally the sort is   conducted in a case-insensitive fashion    What type of structure data in courses table   If you frustrated you can put into array and return using PHP   Use natcasesort for order in  natural order    Reference  http   php net manual en function natcasesort php   Your array from database as example   array db    result from db    final result   natcasesort  array db    print r  final result

[php] Codeigniter $this->db->order_by(' ','desc') result is not complete

Examples related to php

Examples related to codeigniter