note 108807 modified in internals2.opcodes.mod by danbrown

Might be helpful:

I had to create and "INSERT INTO" on every 50th row:

<?php
$lineBreak = 50;
$tableName = 'user';
$tableFields = 'id, name, password';
?>

in the loop:

<?php
if ($counter === 0 || $counter % $lineBreak === 0) {
 echo "INSERT INTO $tableName ($tableFields) VALUES (";
} else {
 echo ' (';
}

// add values comma-delimited

if ($counter === 0 || $counter % $lineBreak === 0) {
 $insertStmt .= ');';
} else {
 $insertStmt .= '),';
}
?>

(in my case I had to check if $no % $o === 0) --was-- Might be helpful: I had to create and "INSERT INTO" on every 50th row: $lineBreak = 50; $tableName = 'user'; $tableFields = 'id, name, password'; in the loop: if ($counter === 0 || $counter % $lineBreak === 0) { echo "INSERT INTO $tableName ($tableFields) VALUES ("; } else { echo ' ('; } // add values comma-delimited if ($counter === 0 || $counter % $lineBreak === 0) { $insertStmt .= ');'; } else { $insertStmt .= '),'; } (in my case I had to check if $no % $o === 0) http://php.net/manual/en/internals2.opcodes.mod.php