"1) open the DB, 2) split the fields in the file by pikes, 3) and the foreach print of the fields. "
hey there, some quick answers-- these should get you going in the right direction
1) look in the notes at the bottom of php.net/fopen or php.net/fread. you should find everythign you need there to get the file into a variable.
2) split the fields using 'explode' on each line. see php.net/explode for examples.
3) to step through each line, the foreach would look like:
-- read the file into an array called $filearray
foreach($filearray as $v) {
$g = explode("", $v);
echo "field 0 is $g[0], field 1 is $g[1]";
}
etc.
this assumes each line in the text file is a record and each field is separate by a '' statement.
you should be able to figure it out from here :-)
best
eric