Skip to content
Browse files

use PMA_countRecordsi where possible

  • Loading branch information...
1 parent ccec5e8 commit ee90fc123c32fee6947e28b283a0e6ee9b0daccd @lem9 lem9 committed Jan 25, 2006
Showing with 2 additions and 0 deletions.
  1. +2 −0 db_search.php
View
2 db_search.php
@@ -116,6 +116,8 @@ function PMA_getSearchSqls($table, $search_str, $search_option)
// Builds complete queries
$sql['select_fields'] = $sqlstr_select . ' * ' . $sqlstr_from . $sqlstr_where;
+ // here, I think we need to still use the COUNT clause, even for
+ // VIEWs, anyway we have a WHERE clause that should limit results
$sql['select_count'] = $sqlstr_select . ' COUNT(*) AS count' . $sqlstr_from . $sqlstr_where;
$sql['delete'] = $sqlstr_delete . $sqlstr_from . $sqlstr_where;

0 comments on commit ee90fc1

Please sign in to comment.
Something went wrong with that request. Please try again.