Modify Text files

[locbtran]

I figure out how to write all the entries from my database onto a text file.

header("Content-Type: text/plain");
header("Content-Disposition: Attachment; filename=test.txt");
header("Pragma: no-cache");
exit;

How do I modify the text file??
Each entries (or row) have 5 elements in it and there are multiple entries in my database.
How do I write each elements follow by a comma onto a text file? Each row in the database would have a new line in my text file as well.

tks

[sunfighter]

I had an old file, dusted it off. It caused me a lot of nightmares so wrote from scratch.

PHP Code:

<?php
require('inc/DB_connect.php');   // Your connect to database
unlink('MyFile.cvs');            // used this because I was writing the file hunderds of times. You may not need
$fp = fopen("MyFile.cvs", "w");  // Opened the file for writting
$DbFile = 'clan_members';        // Put the name of your table here

$result = mysql_query("SELECT * FROM $DbFile");
$row = mysql_fetch_assoc($result);

$line = '';
$comma = '';
foreach ($row as $name => $value)
{
    $line .= $comma . '' . str_replace('', '""', $name);
    $comma = ',';
}
$line .= '\n';
fputs($fp, $line);

mysql_data_seek($result, 0);
$line = '';
while($row = mysql_fetch_assoc($result))
{
    $comma = '';
    foreach ($row as $name => $value)
    {
        $line .= $comma . str_replace('', '""', $value);
        $comma = ',';
    }
    $line .= '\n';
}
fputs($fp, $line);
echo $line;
fclose($fp);
?>