Mysql result in truncate in php : is it a php bug ?

tidou

Hello

I have php 5.0.3 and MySQL 4.1.

That's my problem :

I must do a large query that return me aproximately 23000 results.

The problem is that if my query return me over 2335 result (I have test the exact number that make php crazy) the page leave blank without any error (I have loocked in the html code there is nothing just a blank page without code source) but if my query return < 2334 result it works !

That's my php config :

max_execution_time = 120 ;
max_input_time = 120 ;
memory_limit = 25M ;

So it should not be a memory limit.

What could be the problem please ? Is it a php bug ? :queasy:

My query is like that :

SELECT distinct nom_repertoire, nom_ressource FROM acces WHERE nom_ressource = 'K_Saverne' ORDER BY nom_repertoire ASC

but the problem is not the query that works great but php.

This query works too :

SELECT distinct nom_repertoire, nom_ressource FROM acces WHERE nom_ressource = 'K_Saverne' ORDER BY nom_repertoire ASC LIMIT 2334

but this one not because she return over 2334 result not :

SELECT distinct nom_repertoire, nom_ressource FROM acces WHERE nom_ressource = 'K_Saverne' ORDER BY nom_repertoire ASC LIMIT 2335

How to resolve this problem ? 😕

nemonoman

There are 2 debugging approaches I would take.

Is there some server setup that is limiting the return results?
Is there some bad record(s) that are affecting the returned rows?

Try these two queries:

SELECT distinct nom_repertoire, nom_ressource FROM acces WHERE nom_ressource = 'K_Saverne' ORDER BY nom_repertoire DESC LIMIT 2335

IF you 25,000 records, and record #2335 is a problem, this query should return DIFFERENT rows -- 2335 of them, thus proving the problem is a bad record #2335.

IF this query returns 2334 rows again, it suggests, but doesn't prove, that some setting on your server is limiting the amount of data or the number of rows being returned.

tidou

thanks for reply

in fact, after rebooting my computer, the number of rows is not always 2334 but can be sometines 8000 or less.

I don't know why ... but I have change my approch, and need only aproximately 500 rows from MySQL.

What is the maximum number of row that php can return from MySQL ? Is there a limit, I guess that it depends of the number of memory of each row need ...