Re: CSV output.

Have you opened the CSV file in a text editor? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Tom Shaw wrote: > This statement _is_ correct. I see values such as 234.55, but not 234.00 in > the CSV file and when I dump the data. > 55.00 will equal 55 when it should equal 55.00. 234.00 shows up as 234. The > data is fine it just simple does not show up > correctly in the CSV file. > > $out > > .="".$name.",".$description.",".$size.",".$stock.",".$price.",".$total_cost. > ""; > $out .= "\n"; > > } > > dump($out); This prints the correct data. > exit(); > > header("Content-type: application/vnd.ms-excel"); > header("Content-Disposition: attachment; filename=inventory_report.csv"); > > print $out; This prints wrong. > > -----Original Message----- > From: Eric Gorr [mailto:mailist@ericgorr.net] > Sent: Monday, September 08, 2008 4:21 PM > To: PHP General > Subject: Re: [PHP] CSV output. > > > On Sep 8, 2008, at 5:06 PM, Tom Shaw wrote: > > >> Actually that won't work I tried it. For some reason the .00 shows >> up when I >> try to manually add a .00. I know weird. >> > > Did you mean to say that it .00 _doesn't_ show up when you try to > manually add a .00? > > >> The value is in the array or string >> before outputting printing to CSV. Number format does not work either. >> > > > And just to clarify...in your .csv file, you do see values such as > 234.55, but not 234.00. > > I can promise you that if you fprintf( $fp, "234.00" ), you will see > 234.00 in your file. > > So, the question becomes, what _exactly_ are you doing when you are > writing this stuff out. > > > >