[Phpmyadmin-devel] query results

Dan Allen bigredlinux at yahoo.com
Fri Aug 10 12:18:08 CEST 2001

Sorry for so many posts, but I have a lot of suggestions...

Right now, if you run a query (and not just a browse), it does not
return the total results...it only shows you 0 to 30 and then the
navigation buttons appear depending on whether there are more than 30
results.  The reason for this is in lib.inc.php in the dispaly_table
function.  This is how it should be....

        if (!$is_simple&&!empty($db)) {
            $result = mysql_query($sql_query);
            $total = mysql_num_rows($result);
        } // end if

whereas before it only ran the query for a browse by just counting all
the rows in the table...in fact, what needs to happen is the query needs
to be run again without LIMIT 30,0 to get the total number of rows...it
should be quite fast and maybe this can be a configuration option to
always calculate the total results returned...This way, you can add a
"Show All" button that will break out of the LIMIT, useful when you want
to get all the rows from a search repeatedly...

Dan Allen

More information about the Developers mailing list