Advertisement
Guest User

OrderBy Issue

a guest
Mar 19th, 2013
239
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. $sub1 = $this->subquery->start_union();
  2. $sub1->select('keyword','link','frequency')
  3. ->from('link_result')
  4. ->limit($limit, $offset)
  5. ->order_by($sort_by, $sort_order);
  6. $sub2 = $this->subquery->start_union();
  7. $sub2->select('keyword','link','frequency')
  8. ->from('sub_link_result')
  9. ->limit($limit, $offset)
  10. ->order_by($sort_by, $sort_order);
  11. $this->subquery->end_union();
  12. $q = $this->db->get();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement