kristian_gl Posted May 4, 2010 Share Posted May 4, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/200739-export-table-to-csv/ Share on other sites More sharing options...
Goose Posted May 5, 2010 Share Posted May 5, 2010 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. Quote Link to comment https://forums.phpfreaks.com/topic/200739-export-table-to-csv/#findComment-1053404 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.