You are here: Re: Don't get all records from SQL-table « PHP SQL « IT news, forums, messages
Re: Don't get all records from SQL-table

Posted by The Natural Philosopher on 09/24/07 08:41

LK wrote:
> Hi!
>
> Following script stops after a while (appr. 1 minute) without an error-
> message:
>
> // Loop 12 Times:
> $conn=odbc_connect("database1","","");
> $sql="SELECT * FROM Table1 WHERE id>0";
> $result = odbc_exec($conn, $sql);
> $i=1;
> while (odbc_fetch_row($result, $i)){
> // --- Creating table for display ---
> $i++;
> };
>
> With reading 3000 records, looping 12 times. With the loop ~ 1 to 3
> times the script works.
>
> Is there any timeout-problem (session- and script-timeout are set to
> 1000)?
>
> Regards
> LK
>
A wild guess: Runs out of memory somewhere..

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация