Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6E2D1475458 for ; Wed, 4 Sep 2002 10:27:29 -0400 (EDT) Received: from enterprise.centliq.com (adsl-65-71-224-185.dsl.rcsntx.swbell.net [65.71.224.185]) by postgresql.org (Postfix) with ESMTP id C2720474E61 for ; Wed, 4 Sep 2002 10:27:28 -0400 (EDT) Received: from centennialwines.com (unknown [192.168.1.2]) by enterprise.centliq.com (Postfix) with ESMTP id 13315FF009; Wed, 4 Sep 2002 08:23:50 -0500 (CDT) Message-ID: <3D761759.3020908@centennialwines.com> Date: Wed, 04 Sep 2002 09:23:21 -0500 From: "David C. Brown" User-Agent: Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.0.0) Gecko/20020530 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "dr_sad(surguttel)" Cc: pgsql-php@postgresql.org Subject: Re: Help, plz... References: <171398422475.20020904160909@surguttel.ru> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/14 X-Sequence-Number: 1469 I don't see any generic errors. What I would do is insert debugging statments after DB::connect, after the query, and inside the while loop and see which one fails to show up. (Like "Connected", "Query Returned", and "Looping While...") This should help you find out what command is failing to complete. Hope this helps.. Dave dr_sad(surguttel) wrote: >use: >Linux SuSE 8.0 Pro >PostgreSQL 7.2 >PHP 4.2.2 >Apache 2.0.39 > >All posible deb messages in php.ini are enabled, but follow code: >------------------------------------------------------------------------------- > > > PostgreSQL PHP Test > > > > printf("BEGIN
"); > require_once('DB.php'); > $userid='postgres'; > $password='gecnzr'; > $dbhost='dbserv'; > $database='ll'; > > $db = DB::connect("pgsql://$userid:$password@$dbhost/$database"); > if ( DB::iserror( $db )) > { > die("DB.connect " . $db->getMessage()); > } > > $sql = "select * from agreements"; > $q = $db->query( $sql ); > if ( DB::iserror( $q )) > { > die("Query " . $q->getMessage()); > } > > while ( $row = $q->fetchRow() ) > { > ?> > > > > > > } > printf("END.
"); > ?> >
> > >------------------------------------------------------------------------------- >return follow html: >------------------------------ > > > PostgreSQL PHP Test > > > > BEGIN
>------------------------------ > >can anybody help me? I don't see any error messages both apache and >php logs... :( If I change sitax of command, of course i see error >messages... Heh... > > >