Hi,

I need some help trying to import data from a text file which is to be inserted into a mysql database.

I need to do this through php but i have no idea of how to do this.

Any help would be much great!

The LOAD DATA INFILE command is used to rapidly load data from external text files in MySQL. You should read http://www.mysql.com/documentation/m...html#LOAD_DATA

and
try

mysql> USE db1;
mysql> LOAD DATA INFILE 'data.txt' INTO TABLE db2.my_table;

Hope this helps. As long as your text data is formatted sensibly (eg: tab or comma delimited or something similar) it should be no problem.

----------------------------------------------------------------------

Thanks for that information.

I have successfully entered the data from the text file.