Re: Splitting a CSV file

try to parse the csv file line by line and you won't have memory problems ever: =============================== $d = "\t"; // fields delimiter $fp = fopen ($file_name, "r"); while ($arr_row = fgetcsv ($fp, 4096, $d, "")) { do_something ($arr_row); } fclose ($fp); =============================== (fgetcsv returns an array containing the fields read.) Tiberiu ----- Original Message ----- From: "Chris Payne" <chris@planetoxygene.com> To: <php-db@lists.php.net> Sent: Tuesday, November 25, 2003 1:14 AM Subject: [PHP-DB] Splitting a CSV file Hi there everyone, I'm writing an automation system to automatically insert data into a mysql database from a CSV file, and it works great - until I try to insert a large file, then it just doesn't do anything. I've set my PHP filesize to 10 Megs so that's not the issue, and a server timeout isn't the issue either. So, is that a way that I can split a CSV file into 2 files if it's larger than a certain size so that I can still use the automation I am working on? Actually, I won't see the files as it's for a company who just wants to be able to select their CSV file (No matter what size) and it will insert it automatically, and as I said it does work on small files but not large :-( Any help would really be appreciated. Chris