Posted by Tim Van Wassenhove on 09/06/05 23:55

On 2005-09-06, anom <anommail@hotmail.co.uk> wrote:
> I have a simple loop
> include '../php_library/connect.php';
> include '../php_library/opendb.php';
>
> $conn=mysql_connect($host,$dbuser,$dbpass) or die ('Error');
> mysql_select_db($dbname);
> //Open the file
> $fp = fopen($src,"r");
> //for each line in the file
> while ($row=fgetcsv($fp,10000,';')) { //Get line
> $sql_insert="INSERT INTO ...";
> if (!mysql_query($sql_insert,$conn)){
> OutputError($sql_insert,$mysql_error());
> $FailedCount++;
> }
> else {$InsertCount++;}
> }
>
>
> It works fine for the first couple of hundred or so rows but the stops -
> no errors, it just stops mid-loop.

Prepend the following to your script:

ini_set('error_reporting', E_ALL);
ini_set('display_errors', TRUE);

I've got a feeling you will see a message like: max execution time has
been exceeded... http://www.php.net/set_time_limit


--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>

[Back to original message]