How to insert to DB from txt??? Please help
| From: | Kelvin | Date: | Fri, 04 Jan 2002 16:44:14 +0000 |
| Subject: | How to insert to DB from txt??? Please help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15396@lists.php.net to get a copy of this message | ||
Hi everyone,
I have a txt file which is contained the following:
xxxx,aaa,ccc,ddd
xxxx,aaa,ccc,ddd
.....etc.
Now, I need to read the data from that file and than insert it into the
table.
----insert into Table
("name","pass","phone","somethingelse")
Could someone help me out here, How to write the code?
I know how to read from a txt file, but I don't know how to separate the
data determine by ","
Please help, I'll be very appreciate.Thanks
Kelvin.