inserting more than 10k rows with 1 mysq

[lordgreg]

hi...

my problem is,.. that i have a $var set like this:

$var = "INSERT INTO table (col1, col2) VALUES ('blah', 'blah'), ('blah2', 'blah2'), ('blah3', 'blah3'),... ";

the problem is... i want to insert more than 10.000 rows with one mysql_query call.

when i do $result = mysql_query ($var) or die (mysql_error ()) i get error "MySQL server has gone away". why?

when using phpmyadmin and if inserting a SQL file in it there is no such problem. doesn't matter how many rows i want to insert into a table.

but i MUST use the php coding (and not phpmyadmin) to insert that 10k rows. can you please tell me how to do that?

thank you very much and best best regards!

[bastien]

Where does your data come from? My guess is that you will need to create a loop to interate through whatever form your data is in now and step through the load one by one.

hth

Bastien