Ok Here is my select statement
Select * From customers Where rep_id=$repid And $rptkind = $yn AND processed='n' INTO OUTFILE '/home/callcenter/www/rptdwn/$filename' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n'";
Is there anyway possible to stripslashes() out of this file before or after its created and keep new line chars?? We are using this file to import sales into ACT.
Doing it as is renders an address 1234 Any St. to look like this 1234\Any \St. and our ACH processor is getting pissed and Declining sales because of the addy problem.
I tried doing it this way
$rpt= fopen($mysfile, "r");
$contents = fread ($rpt, 8192);
fclose($rpt);
$contents1 = stripslashes($contents);
$create = fopen($filename2, "x+");
fwrite($create,$contents1);
fclose($create);
But I get errors because I cant create files in this Directory (chmod 777). Is there anyway to do this?? I tried displaying to the screen by using
echo $contents1
But I think I am losing the \n so ACT sees it as one giant file. Since this is an Intranet only app I thought about compiling Apache to run as root but talked myself out of it.
Please Help
