To make it download, use "header" to set your content type:
header("Content-type: text/tab-separated-values\n\n");
Make sure the above is the first this the script outputs, and the only other
thing it outputs is data.
Take your code that spits out the data in html, strip out all the html, then
separate the values with a tab (\t), and a carriage return at the end.
So, while looping through the results:
print "$db_1\t$db_2\t$db_3\r";
That gives you tab separated data, with one row per line.
HTH,
Peter Janett
~~ New Media One Web Services ~~
"Web Hosting for Web Developers"
New Upgrades Are Now Live!!!
Windows 2000 accounts - Cold Fusion 5.0 and Imail 7.1
Sun Solaris (UNIX) accounts - PHP 4.0.6, mod_perl/1.25,
Stronghold/3.0 (Apache/1.3.22), MySQL 3.23.43
PostgreSQL coming soon!
http://www.newmediaone.net
[EMAIL PROTECTED]
(303)828-9882
- Original Message -
From: "Phillip S. Baker" <[EMAIL PROTECTED]>
To: "PHP Email List" <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 2:54 PM
Subject: Re: [PHP] RE: Creating Tab-Delimited Text File
> At 01:42 PM 2/7/2002, Andrew Chase wrote:
> >Which part are you having trouble with, specifically? The task as you've
> >described it is very straightforward, almost pseudo-code. :)
> >
> >-Andy
>
> I know very well how to do the Db query and then loop through the results
> to display the info on an HTML page.
> However I have not done the part about actually creating a new file in the
> text format make sure the results are tab-delimited and then make it
> available for download.
>
> Can you help me with that part specifically?
>
> Thanks
> Phillip
>
>
> > > -Original Message-
> > > From: Phillip S. Baker [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, February 07, 2002 12:32 PM
> > > To: PHP Email List
> > > Subject: Creating Tab-Delimited Text File
> > >
> > >
> > > Greetings All,
> > >
> > > What I want to do is create a tab-delimited text file for download
from
> > > records in a database.
> > > I am not sure on how to do this.
> > >
> > > So what I want to do is as follows.
> > > ON a page a button is clicked.
> > > Script is activated that pulls records from a database.
> > > From these records a tab-delimited text file is created.
> > > A save dialogue box appears so the user to save the text file to
> > > his harddrive.
> > >
> >
> >
> >--
> >PHP General Mailing List (http://www.php.net/)
> >To unsubscribe, visit: http://www.php.net/unsub.php
>
> Blessings
>
> Phillip
>
> Those who give up essential liberty for a little safety,
> deserve neither liberty nor safety.
> - Ben Franklin
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
