Okay so I'm trying to do simple things and can't seem to get anything working. Can someone tell me what is wrong?
Structure is such:
file called load.php is located in /feed/1132 along with the data text files
below is the code. Why isn't it working?
$dbc=mysql_connect ("localhost", "shopn8_imptinv",
"greenimpt") or die('Cannot connect to the database because: ' . mysql_error());
mysql_query("LOAD DATA INFILE '20090401_1132.txt' INTO TABLE invdat FIELDS TERMINATED BY '|' LINES TERMINATED BY '\r\n' IGNORE 1 LINES");