X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AB08DD1B530 for ; Tue, 9 Mar 2004 18:18:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 17729-03 for ; Tue, 9 Mar 2004 14:18:13 -0400 (AST) Received: from hosting.commandprompt.com (224.commandprompt.com [207.173.200.224]) by svr1.postgresql.org (Postfix) with ESMTP id 65EF5D1BA45 for ; Tue, 9 Mar 2004 14:18:11 -0400 (AST) Received: from commandprompt.com (dsl093-038-087.pdx1.dsl.speakeasy.net [66.93.38.87]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id i29IIAp23494 for ; Tue, 9 Mar 2004 10:18:10 -0800 Message-ID: <404E0A5C.1020805@commandprompt.com> Date: Tue, 09 Mar 2004 10:18:04 -0800 From: Robby Russell Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 0.5 (X11/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: pgsql-php@postgresql.org Subject: Re: Please help: PHP4/postgres db woes References: <00a001c40531$cb08e270$0301a8c0@Mesa.com> <0A26E2F5-71E3-11D8-ABD1-000A95EB456A@dotgeek.org> In-Reply-To: <0A26E2F5-71E3-11D8-ABD1-000A95EB456A@dotgeek.org> 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: 200403/29 X-Sequence-Number: 2628 David Costa typed this on 03/09/2004 08:01 AM: > Hello Danny, > I can't go through your whole script but I recommend you use Pear::DB as > an abstraction layer for the pgsql connection and interaction. > This will give you more power with the debug and you can keep everything > simple IMHO. > > More info at > http://pear.php.net/manual/en/package.database.php#package.database.db > > It is default on PHP, so you don't even need to install anything. I'll second this. When he can get the SQL syntax down, then he should play with PEAR. :-) However, I think knowing the standard pg_connect(), pg_query() commands would be useful..then when he goes to try PEAR, he'll see how much time and more useful it can be. my 34 cents, -Robby -- Robby Russell, | Sr. Administrator / Lead Programmer Command Prompt, Inc. | http://www.commandprompt.com rrussell@commandprompt.com | Telephone: (503) 222.2783