Not sure if this helps, but when I developed an in house app for my company
I have to migrate from very messy access db to mysql and I still have to
import once a week from the old db as other people still use it.
I just setup an array with oldtable and newtable then oldfield, newfield
etc. then parse through that array with a loop that inserts the new value
line for line and it works fine for me.
There is possibly a better way of going about it, but this works for me.
-----Original Message-----
From: John Patrick [mailto:[EMAIL PROTECTED]] 
Sent: 9 October 2002 00:15
Subject: [PHP-DB] Dynamic data from user file

    I currently am using the fgetcsv function to read in fields from a
user-defined file.  The delimited file is read and displayed just fine.

    Firstly, what I'm trying to accomplish:  The MySQL database has a table
with about 30 fields.  The user-defined file may contain only some of these
fields and in no particular order.  I'm trying to achieve a way for the user
to specify what each field is so the insert into MySQL is done correctly.
(An analogy would be a custom import.

    The problem I'm having is finding the best way to go about this.  I've
been able to read in the data via fgetcsv and dynamically displaying a drop
down box above each field with all possible choices but am unable to create
a way to link the two for each field successfully.  Been looking for
solutions as well as trial and error to no avail. Any suggestions? -Sean.

PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to