[SOLVED] Export to CSV!

[budimir]

Hey guys,

 

I need some help with the export to CSV. I need to export only some fields from the DB to CSV. Some of those fields I need to limit to 35 chaaracters, change number format from 1,234.00 to 1234.

 

I now how to export to CSV, but I need help with adjusting the result. Can you help me with that???

[PFMaBiSmAd]

To only select the first 35 characters of a field, use the mysql LEFT() function in your select statement -

 

LEFT(str,len)

 

Returns the leftmost len characters from the string str, or NULL if any argument is NULL.

 

mysql> SELECT LEFT('foobarbar', 5);

        -> 'fooba'

 

 

To format a number in your select statement use the mysql FORMAT() function -

 

FORMAT(X,D)

 

Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string. If D is 0, the result has no decimal point or fractional part.

 

mysql> SELECT FORMAT(12332.123456, 4);

        -> '12,332.1235'

mysql> SELECT FORMAT(12332.1,4);

        -> '12,332.1000'

mysql> SELECT FORMAT(12332.2,0);

        -> '12,332'

 

 

 

[Haggis]

<?php
$number = number_format (1234.567, 0, '', '');
echo $number;
?>

 

 

this give the output 1235 coz it rounds up

 

if you want 2 decimal places i.e. the pennies

 

make it

 

<?php
$number = number_format (1234.567, 2, '', '');
echo $number;
?>

[budimir]

OK, I think I'm getting an idea.

 

Thnx.