[RESOLVED] 2 dimensional array to csv

[brianbaart]

Dear All,

I need to get a query from MySQL to a csv file.
But I need to add some data and empty variables into the csv line.
I get a file with 9 lines (which is correct) but the lines contain just the word "array"
I have following code:

<?php
	
	include("conf.php");

	$con = mysql_connect($host, $user, $password);

		if (!$con)
		 {
		 	die('Could not connect: ' . mysql_error());
		 }

	mysql_select_db($name, $con);

	$sql = "SELECT * FROM D2D WHERE GeExporteerd = 'NEE' ORDER BY D2D_ID";

	$result = mysql_query($sql);

	$list = array();

	while($row = mysql_fetch_array($result))
	{
//it goes wrong here, I think. I need to add some variables into the array //here.
		$list[] = array($row['D2D_ID'],$row['CallNummer']);
	} 
		
	$file = fopen($CSV_Adres . "Contact.csv","w");

	foreach ($list as $line)
	{
		fputcsv($file,split(',',$line));
	 }

	fclose($file);

	mysql_close($con);

?>

What did I do wrong?
I have been testing all day.
Thanks in advance,
Brian

[kows]

well, you're defining $list as an array of values of $row[2d2_id] and $row[callnumber]. then, when you are writing the CSV file, $line is an array and you are trying to split an array into an array using a comma delimiter, which.. just wouldn't work.

instead, do:

    foreach ($list as $line)
    {
        fputcsv($file, $line);
     } 

[brianbaart]

Dear All,

Thanks Kow, I have been testing and trying all day but didn't look at that line because I had used it before and it is/was working.

Looking back now I feel stupid.

Thanks again,
Brian