Im trying to insert 1080 records into mysql.
I extract the raw data from a table. place into a array. which is then split into an array (each element containing a record)
I run a FOR loop to insert into the db.
The problem: Only 855 records seem to get inserted : with no errors
$thedata_rawL1=explode("\n",$thedata_raw);
foreach ($thedata_rawL1 as $v)
{
$sql_insertloop="INSERT INTO ori_data (LOAD_ID,THEDATA) Values('$new_LOAD_ID','$v')";
$change_rs = mysql_db_query("originsuk",$sql_insertloop,$connect);
}
Can any one shed some light why i can only enter 855 when i have over 1000. I dont get no error messages.
im using mysql 4 with php 4