Export MySQL table in CSV format using PHP

mysql_csv_export.php

<?php
$link = mysql_connect($mysql_host,$mysql_user,$mysql_pass) or die('Could not connect: '.mysql_error());
mysql_select_db($mysql_db,$link) or die('Could not select database: '.$mysql_db);

$query = "SELECT * FROM $tablename ORDER BY id";
$result = mysql_query($query) or die("Error executing query: ".mysql_error());
$row = mysql_fetch_assoc($result);
$line = "";
$comma = "";
foreach($row as $name => $value)
{
  $line .= $comma . '"' . str_replace('"', '""', $name) . '"';
  $comma = ";";
}
$line .= "\n";
$out = $line;

mysql_data_seek($result, 0);

while($row = mysql_fetch_assoc($result))
{
  $line = "";
  $comma = "";
  foreach($row as $value)
  {
    $line .= $comma . '"' . str_replace('"', '""', $value) . '"';
    $comma = ";";
  }
  $line .= "\n";
  $out.=$line;
}
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename=listino.csv");
echo $out;
exit;
?>