$myFile = "test.txt";
$fh = fopen($myFile, 'w') or die("can't open file"); 

$query = "select * into outfile '$myFile' from  <tablename>";
$result = mysql_query($query);

fclose($fh);