Upload text delimited field

[jbachris]

I'm trying to use an upload file form:

<input name="upload" type="file">

I want to upload a comma delimited text file that is structured like:
ID,Date,Team1,Team1Name,Team1Score,Team2,Team2Name,Team2Score,Detail

What I'd like to do is have some PHP (and mySQL) that'd take that comma delimited file and insert it into the database, and if the ID in the file is already in the DB to overwrite it.

Any help would be greatly appreciated.

[NogDog]

See Handling File Uploads and [man]fgetcsv/man for uploading and parsing the file. As far as overwriting the same ID in the DB, define that column as the primary key, and use "REPLACE" instead of "INSERT" for your query.