Hi,
I have php pages that fetch data from MySQL and displays it in table format. I need to be able to have export to excel link and have it prompt to save the page as an excel file.. Any ideas on an easy way to do this? Is there a query which creates a csv file or any other ideas?

    I'd recommend searching this forum on 'Excel'. You'll find that it's really quite easy to do in most situations. However, if you have fields that contain alot of text (and formated text) you'll probably want to look up one of the Pear bundles that deal with that.

    In a nutshell though...get your query...create a string with your info (a loop) and then output it to the screen or the desktop with the correct header.

    Good luck...

      Write a Reply...