Export MySql table data to CSV

<?php
$dbServer = 'localhost'; 	
$dbUser = 'root';       	
$dbPass  = '';        
$dbName='db';  
$table = 'test';

$dbl =@mysql_connect($dbServer,$dbUser,$dbPass);
mysql_select_db($dbName,$dbl);
mysql_query('SET NAMES utf8');

$result = mysql_query('show columns from '.$table.'');
$num = mysql_num_rows ($result);
$csv_out = '';
$values = mysql_query('select * from '.$table.'');
	while ($row = mysql_fetch_row($values)) {
		for ($j=0;$j<$num;$j++) {
		$csv_out .= '''.$row[$j].''';
		if($j < ($num-1)){$csv_out .= ';';}
		else{$csv_out .= '';}
		}
	$csv_out .= 'n';
	}

$filename = $table.'_'.date('Y-m-d_H-i-s',time());
header('Content-disposition: filename='.$filename.'.csv');
print $csv_out;
exit;
?>