Thread

$sql = $this->db->select()->from($lang . ‘_products’)
        ->where($lang . ‘_product_category_id’, $pcid)
        ->where(‘published’, 1)
                                      ->order_by(‘show_in_top’, 1)
          ->order_by(‘created’, ‘DESC’)
        ->get();

I need firstly order by is ir set to top or and then by creation date. but it messing up some thing. Any suggestions?

Because the second parameter is either ASC or DESC not 1.

Use where show_in_top, 1