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?
Regards, Loïc
______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif