[Phpmyadmin-devel] About bug #461192

Loïc loic-div at ifrance.com
Wed Sep 19 08:04:02 CEST 2001

Hi All!

Trying to find a way to fix this bug (wrong counted
rows with "group"-queries), I've found that... the
convenient parser to build would be really too complex
and really hard for the server.

Then I'm thinking about an other way to handle
"SELECT" queries ie remove the "LIMIT" clause
that was added by PMA and use:
- "mysql_data_seek" to move to the first record
   that should be displayed;
- a pointer to get only n records.

Of course this will increase a bit the server charge
but not too much since MySQL applies the LIMIT
clause in a second time (it applies it on the internal
result array obtained from the SELECT statement).

Does anybody have a better solution?


ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...

More information about the Developers mailing list