From 8fb5d06a4120554864a4ed271688445543accfff Mon Sep 17 00:00:00 2001 From: kkalev Date: Tue, 16 Apr 2002 14:31:18 +0000 Subject: [PATCH] Add an option to specify the maximum results returned from the sql query --- htdocs/accounting.php3 | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/htdocs/accounting.php3 b/htdocs/accounting.php3 index db8873a..1563714 100644 --- a/htdocs/accounting.php3 +++ b/htdocs/accounting.php3 @@ -136,7 +136,9 @@ EOM; echo << -
+

+Max results returned: + @@ -203,7 +205,7 @@ $order = ($order_by != '') ? "$order_by" : 'UserName'; foreach ($show_attrs as $val) $query_view .= $val . ','; $query_view = ereg_replace(',$','',$query_view); -$query="SELECT $query_view FROM $config[sql_accounting_table] $where ORDER BY $order LIMIT $config[sql_row_limit]"; +$query="SELECT $query_view FROM $config[sql_accounting_table] $where ORDER BY $order LIMIT $maxresults"; echo << -- 2.39.5