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 DE6D6D1B8E7 for ; Fri, 5 Sep 2003 08:43:54 +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 13036-04 for ; Fri, 5 Sep 2003 05:43:24 -0300 (ADT) Received: from lighthouse.MplusB.de (lighthouse.MplusB.de [193.102.49.10]) by svr1.postgresql.org (Postfix) with ESMTP id 5A04FD1B8F5 for ; Fri, 5 Sep 2003 05:43:21 -0300 (ADT) Received: from [193.102.49.130] (helo=compass.MplusB.de) by lighthouse.MplusB.de with esmtp (Exim 3.35 #1 (Debian)) id 19vCBW-0007M3-00; Fri, 05 Sep 2003 10:43:14 +0200 Received: from MplusB.de (gerd@sloop.MplusB.de [193.102.49.177]) by compass.MplusB.de (8.9.3p2/8.9.3/Debian 8.9.3-21) with ESMTP id KAA12808; Fri, 5 Sep 2003 10:43:13 +0200 X-Authentication-Warning: compass.MplusB.de: Host gerd@sloop.MplusB.de [193.102.49.177] claimed to be MplusB.de Message-ID: <3F584CA1.6070205@MplusB.de> Date: Fri, 05 Sep 2003 10:43:13 +0200 From: Gerd Terlutter User-Agent: Mozilla/5.0 (X11; U; Linux i586; en-US; rv:1.0.2) Gecko/20030401 Debian/1.0.2-2 X-Accept-Language: de-de MIME-Version: 1.0 To: Chris FR Cc: pgsql-php@postgresql.org Subject: Re: Strange browser behavior when querying PostgreSql database References: <2a584f81.0309020650.6457780e@posting.google.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/20 X-Sequence-Number: 2297 Chris FR wrote: > 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 .... It looks like a typical M$ problem ;-) most developers use Linux > 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? > have you set error_reporting = E_ALL & ~E_NOTICE in your php.ini ? and no error-output in a bad sql-statement?then i don't know, but i think it's better to make joint-select with ...from 'all joint tables' where ... bye, Gerd -- -------------------------------------------------------- # Gerd Terlutter | Mueller+Blanck Software GmbH # # gerd@MplusB.de | Gutenbergring 38 # # gerd.terlutter@web.de | D-22848 Noderstedt # # tel:0171/6992579 | tel:+49 40 500 171-1 # # Buero:040/500171-17 | fax:+49 40 500 171-71 # --------------------------------------------------------