X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdb_pager.inc;h=c2ae04b6ecbd15b474981232b1fee77c8dfdfc39;hb=bc3bd9da4239732574b92842d5573e3316c749de;hp=1940236d0ed64338d6bed92ffc2c130fc33f18af;hpb=8d0b87e3e7dcf325fd55fe5f8c6fb3b8b45ffaa1;p=fa-stable.git

diff --git a/includes/db_pager.inc b/includes/db_pager.inc
index 1940236d..c2ae04b6 100644
--- a/includes/db_pager.inc
+++ b/includes/db_pager.inc
@@ -290,7 +290,7 @@ class db_pager {
 		if ($count) {
 			$group = $group == '' ? "*" : "DISTINCT $group";
 
-			return "SELECT COUNT(0) FROM (SELECT $group FROM $from $where) row_count";
+			return "SELECT COUNT(*) FROM (SELECT $group FROM $from $where) tmp_count";
 		}
 
 		$sql = "$select FROM $from $where";