Need to find MySQL record and update from CSV file

[paullittrell]

Hello All,

I'm a n00b, with both PHP and MySQL, but have been able to have my way around using bits and pieces from here and there.

What I have is a database and a table in that database that I need to update existing records with information that is received in a CSV file.

The CSV only contains 5 columns: casenumber, shipcode,date,tracking_number,backorder

I have found code snippets that will let me import those record, but I need to update the existing ones.

I need to select based on the casenumber, and then update with the remaining 4 fields. I thought it would be pretty straight forward, and would be able to find plenty of sample of this exact function. But alas I have not. I was wondering if someone here had already invented this wheel and would be willing to share their code.

Thanks,
Paul Littrell

[Bonesnap]

1. Use fgetcsv() to put values into an array.
2. Use array to build a query.
3. Execute query.
4. ?????
5. Profit!