CSV Mysql Update

[The Mog]

hi all,

what i am trying to achieve to no avail is the following

I export values from a mysql db into CSV format for quick updates and that works fine..

www.xarex.com/jantar/admin/pick_csv.php

but as you can see from the page you can select the options that you want to d/l
I am going to make ID compulsary but its not necessary fro the time being,

The problem that i am having is with the update mysql feature
what i need to happen is the first line of the csv is the headings (db field names)
so that when i do the update it only updates the fields that were choosen on the pick_csv page.
now i will have no way of knowing before hand what fields will be choosen so i will have to create the update mysql query on the fly,

I hope this is clear enough

any help will be great

K-

[The Mog]

bump

[litebearer2]

Couple of ideas...

1. Have you considered putting the non-requested data into 'hidden' columns? Then when updating the database from the 'excel csv' file you will have all records at hand.

2. rather than csv file, perhaps a form with the non-requested data in hidden fields?

just an old mind meandering...

Lite...

[The Mog]

The problem with this is ....

I need it to be a csv file so thet the clients can alter multiple records in a very short space of time, being in the computer industry the prices of componants change on a daily bases and if there are 100's of records this can create a problem from a web interface.

The web interface is already built and is working fine, now i just need to complete this section.

Back to the proverbial drawing board i suppose

K-