Re: Question about acessing databases and formatting output
| From: | The Doctor | Date: | Mon, 09 May 2005 15:03:59 +0000 |
| Subject: | Re: Question about acessing databases and formatting output | ||
| References: | 1 2 3 4 5 6 7 8 9 10 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-214782@lists.php.net to get a copy of this message | ||
On Mon, May 09, 2005 at 08:19:47PM +0530, bala chandar wrote:
> Hi,
>
> On 5/9/05, The Doctor <doctor@doctor.nl2k.ab.ca> wrote:
> > On Mon, May 09, 2005 at 08:29:34AM +0530, bala chandar wrote:
> > > On 5/9/05, bala chandar <mbchandar@gmail.com> wrote:
> > > > Hi
> > > >
> > > > On 5/9/05, The Doctor <doctor@doctor.nl2k.ab.ca> wrote:
> > > > > On Sun, May 08, 2005 at 01:49:08PM -0600, The Doctor wrote:
> > > > > > On Sun, May 08, 2005 at 08:56:25PM +0530, bala chandar wrote:
> > > > > > > On 5/8/05, The Doctor <doctor@doctor.nl2k.ab.ca> wrote:
> > > > > > > > On Thu, May 05, 2005 at 05:49:38AM -0600, The Doctor wrote:
> > > > > > > > > On Thu, May 05, 2005 at 10:11:14AM +0530, bala chandar
> > > > > > > > > wrote:
> > > > > > > > > > hi,
> > > > > > > > > >
> > > > > > > > > > On 5/5/05, The Doctor
> > > > > > > > > > <doctor@doctor.nl2k.ab.ca> wrote:
> > > > > > > > > > > This is probably easy, but how does
> > > > > > > > > > > one access a database, mysql or oracle or
> > > > > > > > > > > postgresql,
> > > > > > > > > > > and
> > > > > > > > > > > present the data in a tabular format?
> > > > > > > > > > >
> > > > > > > > > > > --
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > check out
> > > > > > > > > > http://in2.php.net/mysql
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > > Looks good to me.
> > > > > > > > >
> > > > > > > >
> > > > > > > > So far so good except my blobs are appearing as is instead
> > > > > > > > of
> > > > > > > > as an interpret item. What next?
> > > > > > > > > > --
> > > > > > >
> > > > > > > what are you storing in BLOB?
> > > > > > >
> > > > > >
> > > > > > First a .tgf and then a jpg.
> > > >
> > > hey, check out this. this might help you
> > >
> > > http://www.zend.com/zend/trick/tricks-sept-2001.php
> > >
> > >
> > > http://forum.100megswebhosting.com/archive/index.php/t-2971.html
> > > >
> > > > > >
> > > > >
> > > > > Is their a way to embed the third column?
> > > > >
> > > > > And what changes do I need to make to the php code?
> > > > >
> > > >
> > >
> >
> > Seems to be correct. Here is what I think:
> >
> > All the non-blobs are working fine; it is the blobs that are turning up
> > as text instead of data. Can you not tell the PHP scripts the following:
> >
> > if a blob then present the data as binary
> > else
> > present the text
> > endif
> > ?
>
> I think you cannot judge the content of the blob. for text use the
> data type text instead of blob
>
Can you please clarify?
--
Member - Liberal International
This is doctor@nl2k.ab.ca Ici doctor@nl2k.ab.ca
God Queen and country! Beware Anti-Christ rising!
BC, Vote Liberal!!