Dark forces indeed...!
OK, OK... Now I have got it working using a local file on the HDD. Next -
integration with PHP:
using the following syntax:
$Upload=
LOAD DATA LOCAL INFILE '/public_html/CSVFILENAME.CSV INTO etc
does not seem to work and provides no error even though I'm trapping any.
I have a commend that changes the file permissions to read only ALL but
still no joy.
If I use a local file, fine such as C:\CSVFILENAME.CSV but not the above
path (and I checked, the file's actually there sitting and waiting).
Strange.
Any ideas guys...?
--
-
Michael Mason
Arras People
www.arraspeople.co.uk
-
Harlequin [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I am using the following command and it appears to execute but does not
actually load any data:
LOAD DATA LOCAL INFILE 'public_html/CSV/act-export.csv' INTO TABLE
MembersData
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';
Any ideas what I might be missing...?
The file exists, and I must have the path right or would get an error but
still no joy unfortunately...
--
-
Michael Mason
Arras People
www.arraspeople.co.uk
-
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php