Quote:
Originally Posted by jimbona
Hi,
If it is writing 1200 lines a failing, have your tried running a similar query along through PHPmyadmin or similar to see if any of the fields you are pulling are empty.
Do you do any outputting in the page?
try putting in some checking
i.e.
PHP Code:
while($line = mysql_fetch_array($result, MYSQL_ASSOC)){
if(!empty($line))
{
$list[] = $line;
}
}
can you also show a dummy of what $result it?
What type of field/size are you pulling into the array? |
That checking is a good idea, however it still blanks out the page if it goes too many rows.
I checked and the mysql_num_rows tells me that there's 2900+ results. So it's pulling the data properly... it's all there.
However once I start looping it and putting it into the array, it dies.
If I alter the code to just output the fields in $line, it outputs everything quite nicely.
It's dumping the information into the array that causes it to choke out.