Problem importing flat file data into MYSQL

[mclard]

Hi
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...
entry1
entry2
entry3
[code]
$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);
[/code]

[Barand]

try
[code]
$SQL = "LOAD DATA INFILE 'path to file'
          INTO TABLE `user`
          FIELDS TERMINATED BY '  '
          LINES TERMINATED BY '\r\n'";
[/code]