export table to CSV

[kristian_gl]

Hello

 

I have a table in mysql database that I wish to export to a CSV file, I've found a script that does this, but all the fieldnames show up in one cell in Excel, and the rows in one other single cell.

 

I want it to look something like this when I open Excel:

 

Colname1      | Colname2        |Colname3

rowvalue1      | rowvalue2      | rowvalue3

rowvalue4      | rowvalue5      | rowvalue6

 

Kristian

[Goose]

Have you tried the fputcsv function? All you have to do is pass in a file handler and an array of data and it should be good to go.