Inserting tab delimited textfiles into mysql

From: Date: Thu, 19 Dec 2002 11:31:23 +0000
Subject: Inserting tab delimited textfiles into mysql
Groups: php.general 
Request: Send a blank email to php-general+get-128846@lists.php.net to get a copy of this message
I got a tab delimited file which looks like this: let us call it items.txt Type Catalog Number Item Description Side B Producer 12 AAA502 Afu Ra-D&D Soundclash Mic Stance, Premeir,Curt Cazall 12 AC725 Roc Raida/Wayne-O - Gong Show Burn That Ass Roc Raida I want to take all this info and insert it into my mysql dbase. The type is in a table named categories. The rest should go into the table named items. With also the id number off the categorie in it. I have been looking for info on how to do this but I can't find a decent article about it. First off I dump all the records which were already in the dbase. And then it needs to get filled up with the new items.txt I would appreciate your help greets -- Thomas Goeminne

« previous php.general (#128846) next »