I run IIS 5 on Win2K professional at my office, a little intranet going on. Webserver runs off the D:\, php and mysql installed on the C:\ at the default locations. C:\ is FAT32.
I have a php program that imports a .csv file into a mysql db table and then does some simple processing.
When I save the file to the root of C:\, the code below works fine
$fileloc = "c:\Stripped OCR.csv";
$query = "LOAD DATA LOCAL INFILE '$fileloc' INTO TABLE data2 FIELDS TERMINATED BY ',' ENCLOSED BY '\"'";
When I create a "REPORTS" directory at the root and save the file to that location and change the code like so:
$fileloc = "c:\reports\Stripped OCR.csv";
$query = "LOAD DATA LOCAL INFILE '$fileloc' INTO TABLE data2 FIELDS TERMINATED BY ',' ENCLOSED BY '\"'";
the file fails to load. I have the \reports directory in my local path statement, but wondering if I need the path in my php.ini or my.ini. Any ideas? Thanks in advance....
