[PHP-DB] RE: [PHP] mySQL LOAD DATA INFILE

2001-11-06 Thread Niklas Lampén
Found the solution: I had to change row $fpName = tempnam($dir, "tableData"); to $fpName = tempnam("", "tableData"); So file will be created to a temporary directory. Niklas P.S. :) -Original Message- From: Niklas Lampén [mailto:[EMAIL PROTECTED]] Sent: 6. marraskuuta 2001 14:5

Re: [PHP-DB] mySQL LOAD DATA INFILE

2001-11-06 Thread Russ Michell
2 things: > mysql_query($QueryInsert); > print mysql_error(); Should read: $query = mysql_query($QueryInsert) or die(mysql_error()); and: >> It returns "Can't get stat of '/www/publico2/tableData0TMRRy' (Errcode: 13)". what exactly is: "tableData0TMRRy"?? if it should be a file, it should

[PHP-DB] mySQL LOAD DATA INFILE

2001-11-06 Thread Niklas Lampén
I have this code: It returns "Can't get stat of '/www/publico2/tableData0TMRRy' (Errcode: 13)". I'd put this file into mySQL's database dir, but I have no access there. Any ideas how to do this? Inserting file row by row would take like eternity, so that is not a good idea. Niklas