Changeset 4334 for trunk/admin/include/functions.php

Timestamp:

Nov 21, 2009, 8:52:50 PM (14 years ago)

Author:

nikrou

Message:

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

File:

• trunk/admin/include/functions.php (modified) (1 diff)

trunk/admin/include/functions.php

@@ -598 +598 @@
   WHERE category_id = '.$category_id.'
   ORDER BY '.DB_RANDOM_FUNCTION.'()
-  LIMIT 0 OFFSET 1
+  LIMIT 1
 ;';
     list($representative) = pwg_db_fetch_row(pwg_query($query));