Kenny wrote:
Well the problem is how would I create the query?
-Original Message-
From: Uzi Klein [mailto:[EMAIL PROTECTED]
Sent: 01 June 2004 07:36
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: CSV update Mysql feature
It's kinda clear.
What isn't clear is what the problem?
Kenny [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
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
I haven't looked at your page; but the general idea would be to test what
options are selected and dynamically build your query accordingly. Eg,
assuming your info is coming from POST:
$query = SELECT id;
if(isset($_POST['name'])) { $query .= , name; }
// more of the same for each field
$query .= FROM table WHERE where ORDER BY whatever;
Or something like that. Then you output in csv format with echo or print or
sprintf or whatever
--
David Robley
Don't hate yourself in the morning - sleep till noon.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php