CSV update Mysql feature
| From: | Kenny | Date: | Mon, 31 May 2004 09:16:37 +0000 |
| Subject: | CSV update Mysql feature | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34591@lists.php.net to get a copy of this message | ||
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..
<http://www.xarex.com/jantar/admin/pick_csv.php>
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 compulsory but its not necessary for 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 chosen
on the pick_csv page.
Now I will have no way of knowing before hand what fields will be chosen
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-