[PHP-WIN] load data infile

2004-03-14 Thread Bobo Wieland
This code... $q = "LOAD DATA INFILE '".str_replace("\\","/",$sqlfil["tmp_name"])."' REPLACE INTO TABLE sortiment"; $res = mysql_query($q, $link_id); print(mysql_affected_rows($link_id)."".str_replace("\\","/",$sqlfil["tmp_name"])); ...gives the output: -1 C:/WINDOWS/TEMP/php1D0.tmp Any ide

[PHP-WIN] load data infile problem

2002-01-19 Thread rop30999
I have a called file cats.txt which count data that were solitary of a DB Access. I need to export these data for a table 'cats' inside of a DB done in MySql. In MySql I can execute this procedure in the following way: Load data local infile "gatos.txt" into table gatos fields terminated by ','