writing contents of a table to a file

[Anon]

I would like to take everything from my table and create a comma delimenated text file.

i would like my data to appear in the text file like this:

1,john,smith,35,red
2,mary,jane,31,blue
3,jack,black,11,green
.
.
.

i've been trying to use:

$db_name = "some_db";
$table_name = "some_table";

$connection = @mysql_connect("xxx", "xxx", "xxx") or die("Couldn't connect.");

$db = @mysql_select_db($db_name, $connection)or die("Couldn't select database.");

$sql = "SELECT * INTO OUTFILE '/path.../filename/test.txt'
FIELDS TERMINATED BY ','
LINES TERMINATED BY \"\n\"
FROM $table_name
";

$result = @($sql,$connection)or die("$sql");

It is not working though, the file test.txt is not being created in the folder filename.

Also, what if i want the user to specify the file name, can i substitute

'/path.../filename/test.txt' to
'/path.../filename/$filename.txt'

Thanks for any help 🙂

[Anon]

Remove the '@' signs. Because they suppress any errors, even the ones that kill the script (stop executing any more code) it may die before the 'or die' statement. Come back and tell us whether theres any errors outputted.

[Anon]

i dont have any @ signs, i get no error messages, the file just never appears in the folder.

[Anon]

sorry, the last post i meant i removed the @ signs and no error messages appear, i can echo the sql statement and everything looks find, but it never creates the file and puts it in the directory