Welcome Guest, Not a member yet? Register   Sign In
Database query order
#9

(10-21-2019, 10:47 AM)jreklund Wrote: Okey, that means you should look in the "run" function inside Pages_model (possible in application/models).

This is what I did yesterday and fix my problem by adding this to run function:

Code:
public function run($params = array())
    {
        //-----run function code above------------

        if(!empty($params['order'])){
            $this->db->order_by($params['order'], 'DESC');
        }
    }

and append "order" param in my view to order them by date

Code:
$this->template->shortcode('pages', array('template' => 'default', 'id' => '45', 'order' => 'date', 'limit' => '3'))

Thanks for your help!
Reply


Messages In This Thread
Database query order - by chrisco - 10-20-2019, 05:27 AM
RE: Database query order - by jreklund - 10-20-2019, 06:21 AM
RE: Database query order - by php_rocs - 10-20-2019, 06:43 AM
RE: Database query order - by chrisco - 10-20-2019, 06:56 AM
RE: Database query order - by php_rocs - 10-20-2019, 09:53 AM
RE: Database query order - by jreklund - 10-20-2019, 10:15 AM
RE: Database query order - by chrisco - 10-20-2019, 12:41 PM
RE: Database query order - by jreklund - 10-21-2019, 10:47 AM
RE: Database query order - by chrisco - 10-22-2019, 01:07 AM



Theme © iAndrew 2016 - Forum software by © MyBB