[RESOLVED] I need help with exporting mysql table data to an .XLS file. :(

[Kinsbane]

I've got this:

$flag = false;

while($row = mysql_fetch_array($result)) {
	if (!$flag) {
		echo implode(",", array_keys($row));
		$flag = true;
	}

$drs = array();
foreach ($row as $f => $v) {
	array_push($drs, "$v");
}
echo implode(",", $drs)."<br><br>";
}

However, at the top for my header row to identify the column names, it outputs this:

0,id,1,p_name,2,sales_rep,3,req_name,4,phone,5,email,6,req_date,7,pre_app_date,8,approve_by,9,promo_date,10,promo_q,11,sponsored,12,participants,13,objective

I don't want those numbers in there.

And then, in the actual fields themselves, everything is getting output twice, my guess is to correspond to the numbers you see above for each of the column names.

Is there any way to fix this? I can't find any good tutorials on coding this. 🙁

[sneakyimp]

if you just want to output all the records, try this:

while($row = mysql_fetch_array($result)) { 
  $line = implode(",", $row);
  echo $line . "\n";
} 

[Kinsbane]

Okay so I got it outputting to Excel correctly, but I've ran into a problem with date-fields containing dates in UNIX timestamp format (number of seconds since the epoch).

Here's my code:

while ($row = mysql_fetch_row($result)) {
	$line = '';
	foreach($row as $value) {
		if ((!isset($value)) OR ($value == "")) {
			$value = "\t";
		} else {
			$value = str_replace('"', '""', $value);
			$value = '"' . $value . '"' . "\t";
		}
		$line .= $value;
	}
	$data .= trim($line)."\n";
}

What I need is to read each of the date fields (they're not setup as date or datetime in MySQL, by the way, but rather INT(11)) by their field name, and if they're a date field, to translate the timestamp into a readable date by using:

date("M j, Y", $value_from_mysql_row);

Thanks!