Database query order

That's not part of CodeIgniter, you can try to find the function by searching for "function shortcode" and see what parameters it accepts.

Hello jreklund, I found the function

Code:

function shortcode($path = 'pages'){
        $this->load->helper('file');

        $data = [
            //['id' => '', 'text' => '-- Default --'],
        ];
        $layout_files = get_dir_file_info(APPPATH . '/views/shortcodes/'.$path.'/', FALSE);

        if (is_array($layout_files))
        {
            sort($layout_files);
            foreach($layout_files as $key => $file_info)
            {
                $pathinfo = pathinfo($file_info['name']);
                if($pathinfo['extension'] == 'php' && $pathinfo['filename'] != 'default'){
                    $data[] = ['id' => $pathinfo['filename'], 'text' => $pathinfo['filename']];
                }
            }
        }
        header('Content-Type:application/json; charset=utf-8');
        exit(json_encode($data));
    }

@chrisco,

Also, we need more information/code.  The code that you displayed is it in a view?  If so, what controller is calling the view?  Has this code worked before?  Are you seeing error messages?  What version of CI are you using?

Hi php_rocs,
Yes, the code that I displayed is in the view, how can I found out which controller is calling the view? The code is working, but I need it to display the newest 3 publications and not just the first 3 publications in a database like it is now. 
CI version is 3.1.10

Cheers!