Exporting Data from MySQL

[JordanTLClive]

I want to export data from a MySQL database in CSV format. The trouble is... I'm not quite sure how to do this Can anyone help me figure out how to do this? Thanks!

[freddydoesphp]

This should do it

<?
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("dbname");

$fieldq = mysql_list_fields("dbname", "tablename");
$columns = mysql_num_fields($fieldq);

for ($i = 0; $i < $columns; $i++) {
    $fields[] = mysql_field_name($fieldq, $i);
    }
    print implode(",", $fields)."\n";  

$r = mysql_query("select * from tablename");

header("Content-Type: application/octet-stream");
header("Content-disposition: attachment;filename=test.csv");


while($row = mysql_fetch_array($r)) {
    foreach($fields as $field) {
        $tmp[] = $row[$field];
        }
    print implode(",", $tmp)."\n";  
    unset($tmp);
    }
?>