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 2265DD1B979 for ; Tue, 9 Mar 2004 16:05:05 +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 77586-01 for ; Tue, 9 Mar 2004 12:04:52 -0400 (AST) Received: from hosting.commandprompt.com (224.commandprompt.com [207.173.200.224]) by svr1.postgresql.org (Postfix) with ESMTP id 67F5BD1C96F for ; Tue, 9 Mar 2004 12:04:51 -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 i29G4ip12299; Tue, 9 Mar 2004 08:04:45 -0800 Message-ID: <404DEB17.7090902@commandprompt.com> Date: Tue, 09 Mar 2004 08:04:39 -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 To: "Danny O'Brien" , pgsql-php@postgresql.org Subject: Re: Please help: PHP4/postgres db woes References: <00a001c40531$cb08e270$0301a8c0@Mesa.com> In-Reply-To: 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/26 X-Sequence-Number: 2625 Danny O'Brien typed this on 03/09/2004 07:45 AM: > > My next test was an attempt to manually enter values into the database > (called "ourdb" for the sake of this test): > > ourdb=# INSERT INTO usr (id, fname, lname, login, password, admin_flag, > client_id) VALUES (4, 'Fred', 'Friendly', 'Fred', 'xxxxx', 'A', 1) > ourdb-# > Typically, you would end your INSERT statement with a ';' In your example, you do not, otherwise the db would give you back some sort of response. > The database did not accept the new information. Why not? More > questions.... > -Robby -- Robby Russell, | Sr. Administrator / Lead Programmer Command Prompt, Inc. | http://www.commandprompt.com rrussell@commandprompt.com | Telephone: (503) 222.2783