Hi

I wonder why my mySQL server 5.0.24a is not returning all of the rows i
was asking for. The code snippet is:

$db = new mysql_db($db_settings['root']);

$query = 'SELECT zip, latitude, longitude FROM zipcodes_tbl';

$result = $db->sql_query($query);

echo 'Fetching ...<br>';
while($row = $db->sql_fetchrow() ) {
$zipcodes[] = $row;
echo $row['zip'] . '<br>';
}
echo 'Done<br>';

It's always stopping at 79961. Is it mySQL or maybe PHP has some upper
limit for variable capacity?

Thank you
--

Ralph

Ralph wrote:
>
> Hi
>
> I wonder why my mySQL server 5.0.24a is not returning all of the rows i
> was asking for. The code snippet is:
>
> $db = new mysql_db($db_settings['root']);
>
> $query = 'SELECT zip, latitude, longitude FROM zipcodes_tbl';
>
> $result = $db->sql_query($query);
>
> echo 'Fetching ...<br>';
> while($row = $db->sql_fetchrow() ) {
> $zipcodes[] = $row;
> echo $row['zip'] . '<br>';
> }
> echo 'Done<br>';
>
> It's always stopping at 79961. Is it mySQL or maybe PHP has some upper
> limit for variable capacity?
>
> Thank you
Let me answer my own question
The problem was with PHP configuration directive memory_limit being set
to low

Thank you all

--

Ralph