something like:
Code:
$txt_array = file('/path/to/file.txt');
$db = ....connect to db
for($i=0;$i<count($txt_array);$i++)
{
$sql = "insert into something where
}
...
FUCK THAT...
Can't you just format your text file like how the table is formatted and run something like:
>load data infile .....
-- search good for "load data in file" -- that'd be the fastest and easiest if possible.