Im trying to import the contents of a flat text file into a mysql database, what ive got so far kind of works but it only enters the first line. The more i look at it it looks like mysql syntax but im at a loss of what to do. Can anyone offer any advice.
FLAT FILE FORMAT...
$dbname="project"; $dbc = @mysql_connect ('localhost', 'root', '') or die (mysql_error()); @mysql_select_db("$dbname"); $SQL = "LOAD DATA LOCAL INFILE 'path to file' INTO TABLE `user` FIELDS TERMINATED BY ' ' ENCLOSED BY '' ESCAPED BY ' ' LINES TERMINATED BY '\r\n'"; $result = mysql_query($SQL);