db to csv - solved

[eluser]Mirge[/eluser]
[quote author="Mbet" date="1313147187"]hi its me again.. someone please help me generate a downloadable csv file from a query
i tried

Code:

$this->load->dbutil();
$query = $this->db->query("SELECT * FROM mytable");
echo $this->dbutil->csv_from_result($query);

that i found at the user manual but it only echoes the query result at the browser and did not generate csv files. thanks[/quote]

Untested.

Code:

$outputFile = 'myfile.csv';

$fp = fopen($outputFile, 'w') or die("Unable to open $outputFile for writing.");
fwrite($fp, $this->dbutil->csv_from_result($query);
fclose($fp);