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 021EFD1B95D for ; Fri, 5 Sep 2003 13:23:51 +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 35772-07 for ; Fri, 5 Sep 2003 10:23:43 -0300 (ADT) Received: from serdyn (7xxxx7.redshift.co.za [66.8.87.226]) by svr1.postgresql.org (Postfix) with SMTP id 891ECD1B8B7 for ; Fri, 5 Sep 2003 10:23:36 -0300 (ADT) X-Flags: 1000 Received: (qmail 21491 invoked by uid 65534); 5 Sep 2003 08:36:36 -0000 Received: from 215.commandprompt.com (EHLO hosting.commandprompt.com) (207.173.200.215) by mx0.gmx.net (mx001-rz3) with SMTP; 05 Sep 2003 10:36:36 +0200 Received: from postgresql.org (svr1.postgresql.org [64.117.224.193]) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id h858Zu231976 for ; Fri, 5 Sep 2003 01:36:33 -0700 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 90668D1B8BA for ; Fri, 5 Sep 2003 08:28:40 +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 08365-09 for ; Fri, 5 Sep 2003 05:28:10 -0300 (ADT) Received: from mail.fusion-advertising.co.uk (host217-35-101-159.in-addr.btopenworld.com [217.35.101.159]) by svr1.postgresql.org (Postfix) with ESMTP id 88036D1B8B3 for ; Fri, 5 Sep 2003 05:28:07 -0300 (ADT) Subject: Re: Strange browser behavior when querying PostgreSql database Date: Fri, 5 Sep 2003 09:28:07 +0100 Message-ID: <162178.1062768079015.JavaMail.Administrator@serdyn> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Thread-Topic: [PHP] Strange browser behavior when querying PostgreSql database Content-Class: urn:content-classes:message X-MimeOLE: Produced By Microsoft Exchange V6.0.6375.0 thread-index: AcNzHd6o3efVoQTwQ+y7ajSdhfUppQAaabCA From: "Grant Henderson" To: X-Virus-Scanned: by amavisd-new at postgresql.org X-Mailing-List: pgsql-php Precedence: bulk X-GMX-Antivirus: -1 (not scanned, may not use virus scanner) X-GMX-Antispam: 0 (Mail was not recognized as spam) X-fetched-from: gmx.net X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/21 X-Sequence-Number: 2298 Perhaps you are referencing a table (b) that has not been included? -----Original Message----- From: Chris FR [mailto:gras.christophe@libertysurf.fr]=20 Sent: 02 September 2003 15:50 To: pgsql-php@postgresql.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 =3D b.id I solved the problem by modifying the request : SELECT a.* FROM a, b WHERE a.idf =3D 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)