On Thu, 2003-07-31 at 14:31, Roy W wrote: > I have this: > > $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS > TERMINATED BY ',' ENCLOSED BY '" . '"' . "' "; > $result = MYSQL_QUERY($query); > PRINT "<br>$query2<br>"; > > The query doesn't take ... but if I cut and paste the printed response into > the mysql server manually ... works like a charm > > :-(
Try this: $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS TERMINATED BY ',' ENCLOSED BY '\"' "; It'll get rid of your parse error Matt
signature.asc
Description: This is a digitally signed message part
