Export database data into different columns of a csv file

[ethereal1m]

Dear all,

I want to export data from database into a csv file using the following code:

function export()
	{

	$this->load->dbutil();
	$this->db->order_by('id','asc');
	$query = $this->db->get('some_table');
	$enclosure = '';
	$delimiter = ",";
	$newline = "\r\n";
	$data = $this->dbutil->csv_from_result($query,$delimiter,$newline,$enclosure);

		if ( ! write_file('my_directory\data.csv', $data))
		{
			echo 'Unable to write the file';
		}
		else
		{
			echo 'File written!';
		}
	}

Basically it uses csv_from_result to create the layout and later it is written to a file using write_file. I delimit each column with comma (,) and each row with carriage return. However when I open the file from Excel, each column is separated by comma and placed into one cell of Excel instead of different cells. Like this:

 

How can I make so that they are in different cells? What should I used for the arguments?

 

regards,

ethereal1m

[ethereal1m]

I got it, I put

/t

as delimiter instead of comma....