--- "HACKATHORN, TODD (SWBT)" <[EMAIL PROTECTED]> wrote:
> Don't know if this will help, but this is how I
> offer web clients to "save
> as excel" in cold fusion:
>
> <cfif #ViewInExcel# is "Y">
> <cfcontent type="application/vnd.ms-excel">
> </cfif>
>
> the key is to change the content like above. I am
> not sure how to do this
> in PHP. But I am sure if you look around you will
> find it.
>
> Then just output the table, with each field broken
> up by <td> tags.
> No html tags or headings nothing but the table, TD,
> and TH tags need to be
> output. I have just recently started working in
> php, if I get a minute to
> put a example together in php I'll let you know.
> This will ask them if they want to save the file or
> open the file.
>
> The thing is you have to tell the client browser it
> is a type of file that
> it recognizes.
>
> Hope that helps, good luck.
>
> Todd Hackathorn
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 15, 2004 2:33 PM
> To: [EMAIL PROTECTED]
> Subject: need to know how to export database to CSV
> format
>
> I have a php website connecting to mysql database.
> How can i have a user export his database through
> the webpage to csv format?
> I would like the user to have a button he can press
> that would pop up a
> "save as" screen so he can save his database.
> I need to also be able that he can only save HIS OWN
> entries (PERSON_ID =
> *******)
>
> Can anyone direct me to a link that shows how you do
> that or explain to me
> how to do this?
> thanks very much
> Noam
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/[EMAIL PROTECTED]
>
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
