exporting mysql

[Anon]

Does anyone have any idea, if at all possible, how to export data out of a mysql db into a csv file using php?

I want to select, for example, first name and last name and then export then into a comma delimited file.

I would like to do this through something like a save as from and html page.

I know there's a way to go from csv into a db, but i'm looking to do the reverse.

Thanks

[Anon]

SELECT first_name,last_name INTO OUTFILE 'data.txt' FIELDS TERMINATED BY ',' FROM your_table;

Love those manuals...

---JH