[SOLVED] Change File Name

[timmah1]

I have a form that exports everything in the database into a csv file.

 

It works fine, but what I can't figure out is how to change the file to the date for which is selected.

 

This is what I have

$date = $_POST['year']."-".$_POST['month']."-".$_POST['day'];
$file = "$date.csv";

function exportMysqlToCsv($table,$filename = '$file')
...

 

But the file name always ends up being $file.csv.

 

How would I fix this?

 

Thanks in advance

[Lamez]

http://us.php.net/rename

[Lamez]

 

$date = $_POST['year']."-".$_POST['month']."-".$_POST['day'];
$file = "$date.csv";

function exportMysqlToCsv($table,$filename = '$file')

rename($filename, $date);

 

 

[timmah1]

for some reason, i'm getting errors

Warning: rename(export.csv,2008-01-1.csv) [function.rename]: No such file or directory in /home/cheezy/public_html/writegov/admin/exportcsv.inc.php on line 65

 

my code is this

function exportMysqlToCsv($table,$filename = 'export.csv')
{
$date = $_POST['year']."-".$_POST['month']."-".$_POST['day'];
$file = "$date.csv";
rename($filename, $file);

 

This goes with no problem naming the file export.csv, but when I add this rename(), I get the error

[unrelenting]

You probably need to rename it AFTER the script has run it's course.

[timmah1]

I got it.

Thanks for everybody's help