file()

[olly2111]

Hi,
I have the attached code, which gets a remote text file through file() feeds it through an array and adds it to a mysql database.
However when i run the file, my verification text comes up however nothing is added to the database.
My database structure is

CREATE TABLE `tbl_ssdumpplanet` (
  `x` text NOT NULL,
  `y` text NOT NULL,
  `z` text NOT NULL,
  `ruler` text NOT NULL,
  `planet` text NOT NULL,
  `size` text NOT NULL,
  `score` text NOT NULL,
  `position` text NOT NULL
) TYPE=MyISAM;

Can anyone help?

[stolzyboy]

change this

<?
mysql_query("INSERT INTO tbl_ssdumpplanet (x, y, z, ruler, planet, size, score, position) VALUES ('{$aLine[0]}', '{$aLine[1]}', '{$aLine[2]}', '{$aLine[3]}', '{$aLine[4]}', '{$aLine[5]}', '{$aLine[6]}', '{$aLine[7]}')");
?>

to this

<?
$query = "INSERT INTO tbl_ssdumpplanet (x, y, z, ruler, planet, size, score, position) VALUES ('{$aLine[0]}', '{$aLine[1]}', '{$aLine[2]}', '{$aLine[3]}', '{$aLine[4]}', '{$aLine[5]}', '{$aLine[6]}', '{$aLine[7]}');";
$result = mysql_query($query) or die(mysql_error());
?>