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:waprd@comcast.net] Sent: 9 October 2002 00:15 To: php-db@lists.php.net Subject: Dynamic data from user file 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
