Copying MySQL databases into CSV Format

It's really bizarre what it's doing now! It's creating a carriage return on only the first /r but the second /r it just displays the square!

It's not looking like it's going to be one of my good days lol.

 

When I am doing something that requires newlines I always do \r\n so if I needed two I would do \r\n\r\n and that seems to work for me, not sure if it will help you or not.

 

Thanks PS. Worked perfectly. How long have you been PHP coding for? I did Java for 3 years at uni as well as C and C++ and I'm trying to convert my knowledge into PHP but there's a lot of little tricks you can do with PHP that I've still to learn.

 

I have been doing PHP professionally (day job) for 1 1/2 years, as a hobby for close to 3 I think. The little tricks come as you program more and more. The first language I learned was C, then went to VBScript for ASP pages, then I found PHP and have never looked back I still do some C to keep up on it.

I am told Java and PHP are "alot" alike, but, I have never even looked at Java.

 

Just to throw in my $0.02 at the end of this conversation, \r\n (in that order) is the linebreak char for windows, \n is used (alone) on *nix and \r is used on Mac.

 

lol do you not like Unix?

Thanks for the $0.02 Definitely worth knowing.