What's wrong with this SQL statement?

bluetiger

<?PHP
mysql_connect("localhost", "root");
mysql_select_db("netcheck");
LOAD DATA INFILE 'c:\apache\mysql\data\getfile.txt' INTO TABLE netcheck
LINES TERMINATED BY '|'
?>

I get this error:
Parse error: parse error in C:\apache\htdocs\huh.php on line 13

This is line 13: LOAD DATA INFILE 'c:\apache\mysql\data\getfile.txt' INTO TABLE netcheck

I'm trying to load a text file into a database before I run more code to utilize said data...please help??

Lurk

You can't just put an SQL statement into the code and expect it to work.

You need to run it with mysql_query(). ie.

mysql_query("LOAD DATA INFILE 'c:\apache\mysql\data\getfile.txt' INTO TABLE netcheck
LINES TERMINATED BY '|'");

bluetiger

no more error....it's always the simple things I overlook when doing this late at night...
you rule!

will this overwrite existing fields in the table as well?

Lurk

Read this: http://www.mysql.com/doc/en/LOAD_DATA.html

www.php.net and www.mysql.com are good places to find this sort of thing out...

bluetiger

I had a syntax error until I read from the link.

Many thanks!