mysql to csv, no second column

Matt_Parsons

I want to export the contents of my db to a csv file.
I have the code below. I get the file and download it, but its all bundled into one column, not into two like i want it to be.
Any ideas where i am going wrong.

<?
mysql_connect($hostname,$username,$tbpassword) or DIE("DATABASE FAILED TO RESPOND.");
mysql_select_db($dbName) or DIE("Database unavailable");

$result = mysql_query("select * from links");
while($row = mysql_fetch_array($result))
{
$club = $row["clubname"];
$link = $row["link"];
$content = $content. $club ."\t" .$link . "<br>";
}
?>
<?
header("Content-disposition: filename=test.csv");

header("Content-type: application/octetstream");

header("Pragma: no-cache");

header("Expires: 0");

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Test</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>

sarahk

you have a tab between the data which may not be recognised.

this generally works

while($row = mysql_fetch_array($result)) 
{ 
  $club = $row["clubname"];  

  $link = $row["link"]; 
  $content = $content . '"' . $club .'","' . $link . '"<br>"; 
}

I don't know about the <br> but I guess that's enough if you are copying from the browser into excel.

basically the csv format is

"1","All Blacks"
"2","Wallabies"
"3","Springboks"

just copy the 3 lines above into excel to test.

Matt_Parsons

Still no luck, click here http://www.theboyracer.net/mod/csv2.php, download the csv and you will see what i am getting. Its almost like the comma is ignored and just written as part of the text for the first cell.

Matt_Parsons

Resolved.
Code was working as it should, but the code below was confusing excel and causing my unexpected result.
Removed this:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Test</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>

<body>
<? echo $content; ?>
</body>
</html>
and just left this

<? echo $content; ?> and all was fine.