Changeset 4334 for trunk/admin/include


Ignore:
Timestamp:
Nov 21, 2009, 8:52:50 PM (15 years ago)
Author:
nikrou
Message:

Feature 1255 : limit params in sql queries were in wrong order (LIMIT count OFFSET offset)

Location:
trunk/admin/include
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • trunk/admin/include/functions.php

    r4331 r4334  
    598598  WHERE category_id = '.$category_id.'
    599599  ORDER BY '.DB_RANDOM_FUNCTION.'()
    600   LIMIT 0 OFFSET 1
     600  LIMIT 1
    601601;';
    602602    list($representative) = pwg_db_fetch_row(pwg_query($query));

  • trunk/admin/include/functions_history.inc.php

    r4331 r4334  
    162162;';
    163163
    164   // LIMIT '.$page['start'].' OFFSET '.$conf['nb_logs_page'].'
     164  // LIMIT '.$conf['nb_logs_page'].' OFFSET '.$page['start'].'
    165165
    166166  $result = pwg_query($query);
Note: See TracChangeset for help on using the changeset viewer.