On Thu, 13 Sep 2001 16:52, you wrote:
> There is a very good reason !
> The csv file contains world currency's
> The system is updated with the changed currency's only !
> The Master field contains all country currency's , this makes it
> difficult because if i drop the master table and upload the csv there
> will only be a few currency's!
> Coenraad Steenkamp
> ----- Original Message -----
> From: "David Robley" <[EMAIL PROTECTED]>
> Newsgroups: php.general
> To: "Coenraad Steenkamp" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Thursday, September 13, 2001 9:18 AM
> Subject: Re: [PHP] Validate CSV file With Table in Database!!
> > On Thu, 13 Sep 2001 16:37, Coenraad Steenkamp wrote:
> > > I need to compare a csv file to a table in the database but only
> > > one field in the database with
> > > one field in the CSV file! Comparing only one field will make it
> > > much easier! When there is any change in the Database compared to
> > > the CSV file , the database must then be updated or if there are no
> > > such a field it must be added to the table!
> > >
> > > I am new in php Please help!
> > That seems an awful lot of work, if you know that the csv is at least
> > as up to date, if not more so, than the actual table. You might as
> > well just drop the table and import the contents of the csv.
> > Unless there's a good reason not to that you haven't mentioned?
OK. So it sounds like you need to do something like:
for each csv file line
select record where table_key = csvfield_key
if record found
if table_other_value != csv_other_value
update table with csv_value
else (record not found)
insert new record
where the key might be perhaps the country name and the other value is
the current currency.
Am I on the right track? Does that help you any?
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
I am functioning within established parameters.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]