retrieve data & save as file.csv

[nilesh]

well, i have name,age,address as fields in table "mytable". now what i would like to do is let users download a simple info.csv file which contains some specific info.
eg. user X wants to download info in the database where age=12 - basically what I am asking is how to get php to work so that it will retrieve the correct data and prompt to download the file ?

cheers,
nilesh.

[nilesh]

okay, I dont have a windows box. I am working off solaris box so the COM functions are not available to me :-) it is easy , i can change header etc but my problem is how to retreive specific data and then prompt to download....

cheers
nilesh.

[petrb]

This is none too simple to get right. This guy got it right:
http://www.lumbroso.com/scripts/source_view.php?path=csv2sql_code/csv2sql.phps

As far as the query goes, that's pretty straightforward. Make some radios or a dropdown or 2 and take the selections into your WHERE clause.

--ph