Have a suggestion to make a checkbox on accounting page which will enable reverse listing order. It is more convenient (imho) to see it last-like. --- /usr/share/webapps/freeradius-dialupadmin/1.70.3/htdocs/accounting.php 2007-03-01 11:58:34.000000000 +0200 +++ /var/www/adm/htdocs/du/accounting.php 2007-04-28 10:46:54.000000000 +0300 @@ -147,7 +147,7 @@ </select> <br><br> <b>Max results returned:</b><br> -<input name=maxresults value=$config[sql_row_limit] size=5> +<input name=maxresults value=$config[sql_row_limit] size=5> <input type=checkbox name=revers checked> <b>Reverse</b> </td> <td valign=top> <input type=hidden name=add value=0> @@ -219,7 +219,8 @@ ' AND ' . ${"item_of_w$i"} . ' ' . ${"operator_of_w$i"} . " '" . ${"value_of_w$i"} . "'" ; $i++; } - +#phpinfo(); +$reverse = ($_REQUEST["revers"] != 'on') ? "ASC" : "DESC" ; $order = ($order_by != '') ? "$order_by" : 'username'; foreach ($accounting_show_attrs as $val) @@ -228,7 +229,7 @@ $sql_extra_query = ''; if ($config[sql_accounting_extra_query] != '') $sql_extra_query = sql_xlat($config[sql_accounting_extra_query],$login,$config); -$query="SELECT $query_view FROM $config[sql_accounting_table] $where $sql_extra_query ORDER BY $order LIMIT $maxresults;"; +$query="SELECT $query_view FROM $config[sql_accounting_table] $where $sql_extra_query ORDER BY $order $reverse LIMIT $maxresults;"; echo <<<EOM <html> -- Olimp, System Administrator IT Dept. ---- Looking forward to reading yours. RUFF-RIPE DI76-GANDI RUFF-6BONE Ruslan N. Marchenko