exporting to csv format
I had previously, as my website is still in the design phase, using a SELECT INTO OUTFILE query to export selected details to a csv file. I have now noticed that this isnt going to be usefull because I cant export the records to anywhere other than the mysql folder on the host machine. So now I was thinking of using a mysqldump instead, however I dont know how to phrase it, I have tried looking but the answers I have found have been confusing at best.
I was wondering if anyone could give me an example? I just want the details enclosed by " and seperated by ,