每天导出mySql表到文件夹/url

我有一个mySql表，我从一个表单填充信息。我想每天以csv格式导出表格。我希望这个csv可以通过url访问，这样我的客户端就可以简单地输入url并检索/下载csv。

例如，调查在

survey.mywebsite.com

我希望客户端/管理员能够通过访问

访问最新的数据

survey.mywebsite.com/data/mostRecent.csv

假设我的连接php是这样的

        $hostname = "hostname";
        $username = "admin";
        $dbname = "dbName";
        //These variable values need to be changed by you before deploying
        $password = "password";
        $usertable = "surveyTable";         
        //Connecting database
        mysql_connect($hostname, $username, $password) OR DIE ("Unable to 
        connect to database! Please try again later.");
        mysql_select_db($dbname);   

我如何转储名为'surveyTable'的表到文件夹survey.mywebsite.com/data/每天?

我是php的新手，所以请尽可能轻柔地引导我。

SELECT * INTO OUTFILE "data/mostRecent.csv"
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "'n"
FROM surveyTable;