Verner Web Studio

PHP/CSV Tip

Just a quick tip that might help out some other developer out there.  I am using PHP's fgetcsv function to import comma-separated data that has been exported from an Excel spreadsheet.

It was giving me fits though - skipping over null values and throwing everything out of wack.  If you are having this problem, there is a good chance you are using a Mac (like I am) and just saving as a "Comma Separated Values (.csv)" file.  While this seems logical. BUZZZZZZZ! I guess it is wrong.  You have to save as "Windows Comma Separated (.csv)" file.  This solves everything.