Sean,
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.
Cheers
Simon
-----Original Message-----
From: John Patrick [mailto:[EMAIL PROTECTED]]
Sent: 9 October 2002 00:15
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Dynamic data from user file
Advertising
Greetings:
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 (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
