X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1C152D1B89E for ; Tue, 2 Sep 2003 14:53:33 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 69401-03 for ; Tue, 2 Sep 2003 11:53:26 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id 85F07D1B4F0 for ; Tue, 2 Sep 2003 11:53:22 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h82ErMek097887 for ; Tue, 2 Sep 2003 14:53:22 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h82EoYYH097109 for pgsql-php@postgresql.org; Tue, 2 Sep 2003 14:50:34 GMT From: gras.christophe@libertysurf.fr (Chris FR) X-Newsgroups: comp.databases.postgresql.interfaces.php Subject: Strange browser behavior when querying PostgreSql database Date: 2 Sep 2003 07:50:15 -0700 Organization: http://groups.google.com/ Lines: 32 Message-ID: <2a584f81.0309020650.6457780e@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-php@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/14 X-Sequence-Number: 2291 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