Mysql query for save output in excel sheet

<?php
error_reporting(0);
$hostname='localhost'; 
$user='root';
$pass='';
$dbase='database_name';
$connection = mysql_connect("$hostname" , "$user" , "$pass"); 
$db=mysql_select_db($dbase , $connection);

$filename="filename_".date('d-m-Y')."_info.csv";
$date= date("Y-m-d");
$yesterday = date('Y-m-d', strtotime($date. " - 1 day"));

$qry= "SELECT 'field1','field12',DATE_FORMAT(in_date,'%d-%m-%Y')
as in_date,TIME_FORMAT(in_time,'%H:%i'),DATE_FORMAT(out_date,'%d-%m-%Y') 
as out_date,TIME_FORMAT(out_time,'%H:%i'),shift,remark 
FROM tablename where in_date='$yesterday'
INTO OUTFILE 'c:/foldername/$filename' FIELDS TERMINATED BY ','
ESCAPED BY '''' LINES TERMINATED BY '\n'";


$result = mysql_query($qry,$connection);
if (!$result) {
    die('Invalid query: ' . mysql_error());
}else
echo "Please check file in c:/foldername/$filename";
?>