[Phpmyadmin-devel] add LIMIT once? ... or

Hi, if you browse a table, (or any other SELECT ...?) PMA always adds the LIMIT but why is this done at least twice? first it is done in sql.php but the function PMA_displayMessager() is called without the added LIMIT and now this function adds the LIMIT again! what was the reason not doing this once and give PMA_displayMessage() the query with the already added LIMIT? -- Sebastian Mendel www.sebastianmendel.de

Sebastian Mendel a écrit :
Hi,
if you browse a table, (or any other SELECT ...?) PMA always adds the LIMIT
but why is this done at least twice?
first it is done in sql.php
but the function PMA_displayMessager() is called without the added LIMIT and now this function adds the LIMIT again!
what was the reason not doing this once and give PMA_displayMessage() the query with the already added LIMIT?
Hi Sebastian, in PMA_showMessage() there is a comment: // Here we append the LIMIT added for navigation, to // enable its display. Adding it higher in the code // to $sql_query would create a problem when // using the Refresh or Edit links.

Marc Delisle schrieb:
Sebastian Mendel a écrit :
Hi,
if you browse a table, (or any other SELECT ...?) PMA always adds the LIMIT
but why is this done at least twice?
first it is done in sql.php
but the function PMA_displayMessager() is called without the added LIMIT and now this function adds the LIMIT again!
what was the reason not doing this once and give PMA_displayMessage() the query with the already added LIMIT?
Hi Sebastian,
in PMA_showMessage() there is a comment:
// Here we append the LIMIT added for navigation, to // enable its display. Adding it higher in the code // to $sql_query would create a problem when // using the Refresh or Edit links.
yes i read it - this is the only reason? -- Sebastian Mendel www.sebastianmendel.de

Sebastian Mendel a écrit :
Marc Delisle schrieb:
Sebastian Mendel a écrit :
Hi,
if you browse a table, (or any other SELECT ...?) PMA always adds the LIMIT
but why is this done at least twice?
first it is done in sql.php
but the function PMA_displayMessager() is called without the added LIMIT and now this function adds the LIMIT again!
what was the reason not doing this once and give PMA_displayMessage() the query with the already added LIMIT? Hi Sebastian,
in PMA_showMessage() there is a comment:
// Here we append the LIMIT added for navigation, to // enable its display. Adding it higher in the code // to $sql_query would create a problem when // using the Refresh or Edit links.
yes i read it - this is the only reason?
Yes.
participants (2)
-
Marc Delisle
-
Sebastian Mendel