PHP - MySQL query to CSV export

Hi

I have a PHP script. Its a library management system. So after all the books are stored in the database i need to create multiple reports - like clicking a link which will execute the SQL command and export the result to CSV. Can anyone guide me how can we do this CSV export?

Thanks
Sam

http://davidwalsh.name/backup-mysql-database-php

http://davidwalsh.name/backup-mysql-database-php

Hi

I think you got it wrong. all i need is i need a link "Click here to generate CSV" when someone clicks that link, it should execute a query and export that sql query result to a CSV file..

Sam