CVS files with PHP

[Gnub]

Im wondering if it is at all possible, for PHP to create a CVS file from a mySQL database. 

 

If there is a simple mysql - go create a CVS file, and drop it <here> .  Or will i have to go the long way round, and access the database, append each field in a record to a string, save the string to a file, and save it as a *.cvs file.

 

Your thoughts here would be great.

 

Cheers.

[benjaminbeazy]

this will turn a table's data into csv in the format

'data', 'more date', 'more data'

 

may want to use addslashes

 

$sql = "SELECT * from table";
$result = mysql_query($sql);

while($row = mysql_fetch_object($result){
    $string = "";
        foreach($row as $var => $val){
            $string = $string."'".$val."', ";
        }
    echo "$string<br>";
}

[Gnub]

addslashes?  sorry mate, no idea what that is.