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 C3B9AD1B8AE for ; Fri, 5 Sep 2003 12:40:47 +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 29048-06 for ; Fri, 5 Sep 2003 09:40:19 -0300 (ADT) Received: from sccrmhc11.comcast.net (sccrmhc11.comcast.net [204.127.202.55]) by svr1.postgresql.org (Postfix) with ESMTP id 4D63ED1B897 for ; Fri, 5 Sep 2003 09:40:15 -0300 (ADT) Received: from bigbertha (h008019444478.ne.client2.attbi.com[24.60.19.116](untrusted sender)) by comcast.net (sccrmhc11) with SMTP id <2003090512401801100cd6ote>; Fri, 5 Sep 2003 12:40:18 +0000 Message-ID: <003b01c373ab$49f2b2f0$0000fea9@bigbertha> From: "Luis H" To: "Chris FR" , References: <2a584f81.0309020650.6457780e@posting.google.com> Subject: Re: Strange browser behavior when querying PostgreSql database Date: Fri, 5 Sep 2003 08:43:20 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=3.9 tagged_above=0.0 required=5.0 tests=BAYES_30, MSGID_OE_SPAM_4ZERO, QUOTED_EMAIL_TEXT, RCVD_IN_OSIRUSOFT_COM, REFERENCES X-Spam-Level: *** X-Archive-Number: 200309/17 X-Sequence-Number: 2294 Are you sure it freezes on the query? Could it be php code that uses the results from the query that hang the system? -L ----- Original Message ----- From: "Chris FR" To: Sent: Tuesday, September 02, 2003 10:50 AM 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 >