From c5e6fb8c581e8f90f336090ffeeaf318060eb42f Mon Sep 17 00:00:00 2001 From: Marc Delisle Date: Sat, 5 Oct 2002 19:48:27 +0000 Subject: [PATCH] row count for InnoDB --- db_details_structure.php3 | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) diff --git a/db_details_structure.php3 b/db_details_structure.php3 index 23087575c1..152fb1c75d 100644 --- a/db_details_structure.php3 +++ b/db_details_structure.php3 @@ -171,7 +171,14 @@ else if (PMA_MYSQL_INT_VERSION >= 32303) { $sum_size += $tblsize; list($formated_size, $unit) = PMA_formatByteDown($tblsize, 3, ($tblsize > 0) ? 1 : 0); } - $display_rows = ' - '; + //$display_rows = ' - '; + // get row count with another method + $local_query = 'SELECT COUNT(*) AS count FROM ' + . PMA_backquote($db) . '.' + . PMA_backquote($table); + $table_info_result = PMA_mysql_query($local_query) + or PMA_mysqlDie('', $local_query, '', $err_url_0); + $display_rows = number_format(PMA_mysql_result($table_info_result, 0, 'count'), 0, $number_decimal_separator, $number_thousands_separator); } // Merge or BerkleyDB table: Only row count is accurate. @@ -530,4 +537,4 @@ echo "\n" . ''; */ echo "\n"; require('./footer.inc.php3'); -?> \ No newline at end of file +?> -- 2.11.4.GIT