|
Posted by Shooter on 08/05/06 04:28
I don't follow you. We're not trying to create a CSV, we're trying to either
update or replace an existing database with the most recent data (from a CSV
file)...?
Thanx,
Wm
"J.O. Aho" <user@example.net> wrote in message
news:4jijvlF86g2iU1@individual.net...
> Shooter wrote:
>> I have a colleague who's web designer has gone MIA. He set up a process
>> on her hosting account to allow her to download a .CSV membership roster
>> and dump it in to an FTP folder. The website would automatically
>> update/replace the online roster with the new/updated data. I'm assuming
>> that something triggered a MYSQLIMPORT command, but I noticed that she
>> had CRON turned off on her control panel so presumably he used another
>> method to make this work. Anyone have any suggestions on the best or
>> easiest way to allow her to dump a file somewhere and have her mySQL
>> database update the info with any new/changed information?
>
> use a while loop that fetches each line in the database and writes it to a
> file at the same time in the csv format.
>
> Check
> http://www.php.net/manual/en/function.mysql-fetch-array.php
> http://www.php.net/manual/en/function.fwrite.php
>
>
> //Aho
Navigation:
[Reply to this message]
|