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

Posted by LK on 09/24/07 08:11

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

 

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

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