PHP errors

[sp@rky13]

So I'm doing this to import and unzip a text file:

 

cd www/tw/data/9 && rm village.txt.gz ; wget http://en9.tribalwars.net/map/village.txt.gz && rm village.txt ; gunzip village.txt.gz

 

And then to put it into a database I tried this but it failed:

 

$connection = mysql_connect("*********","********","*********");
mysql_select_db("********", $con);
mysql_query("TRUNCATE `village9`");
$load = mysql_query("LOAD DATA LOCAL INFILE '../data/9/village.txt' INTO TABLE `village9` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (id, name, x, y, owner, points, rank)");
if (!$load) {
    die('Invalid query: ' . mysql_error());
}

 

Anyone see the problem?

[oni-kun]

What is the error mysql_error() gives you? That'd be helpful.

[sp@rky13]

Im' doing it as a cron job and get this error:

 

/bin/sh: -c: line 0: syntax error near unexpected token `('

/bin/sh: -c: line 0: `$connection = mysql_connect("*********","********","*********");

mysql_select_db("********", $con);

mysql_query("TRUNCATE `village9`");

$load = mysql_query("LOAD DATA LOCAL INFILE '../data/9/village.txt' INTO TABLE `village9` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (id, name, x, y, owner, points, rank)");

if (!$load) {

    die('Invalid query: ' . mysql_error());

}

[sp@rky13]

I asked about this on my hosting's forum and got an answer quicker so it's solved