Skip site navigation (1) Skip section navigation (2)

Re: Strange browser behavior when querying PostgreSql database

From: "Grant Henderson" <granth(at)fusion-advertising(dot)co(dot)uk>
To: <pgsql-php(at)postgresql(dot)org>
Subject: Re: Strange browser behavior when querying PostgreSql database
Date: 2003-09-05 08:28:07
Message-ID: 31EA81C61A3D014F8D6933864F32C60413C881@server1.fusion-advertising.co.uk (view raw or flat)
Thread:
Lists: pgsql-php
Perhaps you are referencing a table (b) that has not been included?
-----Original Message-----
From: Chris FR [mailto:gras(dot)christophe(at)libertysurf(dot)fr] 
Sent: 02 September 2003 15:50
To: pgsql-php(at)postgresql(dot)org
Subject: [PHP] Strange browser behavior when querying PostgreSql
database


Hi,

I have a problem in a php script :

when I execute it via Internet Explorer , sometimes the source is
complete (no problem), sometimes the source is incomplete (the html page
is cutted), and sometimes the browser doesn't display anything and wait
and wait and wait ....

The problem comes from a request I peform in this PHP script :

when I do the following request I have the problems quoted above :

SELECT a.* FROM a WHERE a.idf = b.id

I solved the problem by modifying the request :

SELECT a.* FROM a, b WHERE a.idf = b.id

Now the script works.

But I don't understand why the first request causes those problems ?

Is the first request has a correct syntax ? ( when submitted to
Postgres, there is no error message , and the results are displayed) Is
it due to PHP ? or PostgreSQL?


Thanks in advance,


Christophe Gras

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


pgsql-php by date

Next:From: Gerd TerlutterDate: 2003-09-05 08:43:13
Subject: Re: Strange browser behavior when querying PostgreSql database
Previous:From: Christopher Kings-LynneDate: 2003-09-04 06:17:12
Subject: Re: Case sensitivity when searching for and displaying data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group