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 be called
'myfile.txt' (with
a file suffix)
HTH
Russ
On Tue, 6 Nov 2001 14:56:00 +0200 =?iso-8859-1?Q?Niklas_Lamp=E9n?=
<[EMAIL PROTECTED]> wrote:
> I have this code:
>
> <?
> $dir = getcwd();
>
> $fpName = tempnam($dir, "tableData");
> $fp = fopen($fpName, "w");
> fputs($fp, $strData);
> fclose($fp);
>
> $QueryInsert = "
> LOAD DATA INFILE '$fpName'
> INTO TABLE feStatics
> FIELDS TERMINATED BY '|'
> LINES TERMINATED BY '\n'
> ";
>
> mysql_query($QueryInsert);
> print mysql_error();
>
> unlink($fpName);
> ?>
>
> 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
#-------------------------------------------------------#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#-------------------------------------------------------#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
