Hi,

I want to create a script that will import a cvs file into a mysql database, I wanted to this autmatically.

Does anyone has a sample script or good sites where I could find these scripts.

Thanks in advance,

Avanti

Hi,

I forgot to mention my operating systeem.

I'm using:

FreeBSD 4.9
Apache (webserver)
PHP
IMAP
Sendmail
HORDE/IMP

You can create a simple sql file that use load data to import your file
And just run this script in a cron job

If you need to know how to use load data
see

http://www.lasso-developpeur.net/us/...tab=db&lang=us

You also could use the plain text or csv files and import by LOAD DATA INFILE