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]

Reply via email to