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!
> Thanks
> Coenraad Steenkamp
> ----- Original Message -----
> From: "David Robley" <[EMAIL PROTECTED]>
> Newsgroups: php.general
> To: "Coenraad Steenkamp" <[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
    end if
  else (record not found)
    insert new record
  end if
end for

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

   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]

Reply via email to