Index: trunk/globals.php =================================================================== diff -u -r889 -r890 --- trunk/globals.php (.../globals.php) (revision 889) +++ trunk/globals.php (.../globals.php) (revision 890) @@ -208,8 +208,10 @@ $sql = preg_replace('/SELECT(.*)FROM[ \n\r](.*)/is','SELECT COUNT(*) AS TableCount FROM $2', $sql); $sql = preg_replace('/(.*)LIMIT(.*)/is','$1', $sql); $sql = preg_replace('/(.*)ORDER BY(.*)/is','$1', $sql); - echo $sql; - $db =& GetADODBConnection(); + + //echo $sql; + + $db =& GetADODBConnection(); return $db->GetOne($sql); } Index: trunk/admin/users/adduser_items.php =================================================================== diff -u -r881 -r890 --- trunk/admin/users/adduser_items.php (.../adduser_items.php) (revision 881) +++ trunk/admin/users/adduser_items.php (.../adduser_items.php) (revision 890) @@ -272,6 +272,8 @@ $objListView->CurrentPageVar = "Page_Items"; $objListView->PerPageVar = "Perpage_Items"; +$sql .= $order; + $objItems->Query_Item($sql, $objListView->GetLimitSQL() );