Export into CSV from MySQL

[The_Chancer]

I'm trying to export data into a csv, using

$query=do_query("SELECT * INTO OUTFILE '".$dir."/".$table."-".date("d M Y H-i-s",time()).".csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' FROM `".$table."`");

However, the data includes commas within some text, and so, it splits it incorrectly.

Is there something I'm missing so that it doesn't ??

E.g.
this text will, on occasion, split into three

And I only want it into one field...

Any ideas ?

[edit]
Would set_magic_quotes_runtime to addslashes to the data work ? Testing at the moment.....

[RichieVC]

Try Quoating your data

"date","date",

if the , is with in the quats it will bybass it

good luck

[The_Chancer]

I would but I can't control the data that is inputted....

Hence trying to do it all on the fly....

[bubblenut]

take a look at mysql's string functions there is one called quote and one called replace, maybe one of these would help?