MySQL to CSV Files ... need help !!

[nomad9]

Hi,

i need to export a table of my mySQL db to use it in excel.

The db is based on my server and excel is on my personal computer.

It sound like CSV file is the best way to make this .... so can someone can tell me how i can do that ???

Thanx Steve

[nomad9]

<?
session_start();

header("Content-Type: application/vnd.ms-excel");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

// Start DB Connection
$db = mysql_connect('localhost', '-----', '-----');
mysql_select_db('visionclient_ca',$db);

// Cie -- Def & Name
$sql = "SELECT * FROM f".$clientRef."";
$result = mysql_query($sql,$db);

while ($qx = mysql_fetch_row($result)) {
echo .$qx['formID'].",".$qx['formType'].",".$qx['formName'].",".$qx['formQuestion'].",".$qx['formValue']."\n";
}

// End DB Connection
mysql_close();
?>