How to sort database values in descending order with CodeIgniter? [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed 8 months ago.

Improve this question

I am bit new to CI.I want to sort my database values in descending order using this query below in my model. However, it doesn't work form me and throw errors .please help me out.

   function get_records(){      
    $this->db->from($this->tbl_contactus);
    $this->db->order_by("contactus_id", "asc");
    $query = $this->db->get();
    return $query->result();
}

The error: enter image description here

Your property $this->tbl_contactus is empty according to error — M Khalid Junaid
– M Khalid Junaid, Commented May 18, 2014 at 7:08
that is impossible it works with //$query = $this->db->get('tbl_contactus'); //return $query->result(); — user3454007
– user3454007, Commented May 18, 2014 at 7:11
If you are sure that your property is not empty then add $this->db->select('*') before from function's line it is the correct format to write query with active record — M Khalid Junaid
– M Khalid Junaid, Commented May 18, 2014 at 7:14

Walter White · Accepted Answer · 2014-05-18 13:20:06Z

3

Try like this

   function get_records(){

    $this->db->select("*");
    $this->db->from("tbl_contactus");
    $this->db->order_by("contactus_id", "desc");
    $query = $this->db->get();
    return $query->result();

}

and also you can use this

function get_records(){

    $this->db->select()->from('tbl_contactus')->order_by('contactus_id', 'desc');

}

edited May 18, 2014 at 13:20

answered May 18, 2014 at 10:03

Walter White

861 gold badge1 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

saurabh kamble Over a year ago

You can directly use $this->db->get($tbl_contactus)->order_by('contactus_id',desc)->result();

Walter White Over a year ago

$this->db->select()->from('tbl_contactus')->order_by('contactus_id', 'desc'); is also correct

mickmackusa Apr 28 at 11:30

->select() and ->select('*') are never necessary in CodeIgniter -- SELECT * is the default clause anyhow.

echo_Me · Accepted Answer · 2014-05-18 09:50:56Z

1

you have to check $tbl_contactus because its not defined or empty in that line

  $this->db->from($this->tbl_contactus);

You are using query like that:

    SELECT * ORDER BY contactus_id ASC

while it should be

    SELECT * FROM your_table ORDER BY contactus_id ASC

edited May 18, 2014 at 9:50

answered May 18, 2014 at 7:08

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Collectives™ on Stack Overflow

How to sort database values in descending order with CodeIgniter? [closed]

2 Answers 2

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Related