Ignore:
Timestamp:
Nov 21, 2009, 1:15:22 PM (14 years ago)
Author:
nikrou
Message:

Feature 1255 : improve sql
Replace in queries LIMIT N,M by LIMIT N OFFSET M

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/admin/element_set_unit.php

    r4325 r4331  
    197197  WHERE id IN ('.implode(',', $page['cat_elements_id']).')
    198198  '.$conf['order_by'].'
    199   LIMIT '.$page['start'].', '.$page['nb_images'].'
     199  LIMIT '.$page['start'].' OFFSET '.$page['nb_images'].'
    200200;';
    201201  $result = pwg_query($query);
Note: See TracChangeset for help on using the changeset viewer.