X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 57BAAD1B1D1 for ; Fri, 9 Jul 2004 16:08:23 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 46365-06 for ; Fri, 9 Jul 2004 19:08:20 +0000 (GMT) Received: from themode.com (themode.com [161.58.169.198]) by svr1.postgresql.org (Postfix) with ESMTP id 5CC80D1B184 for ; Fri, 9 Jul 2004 16:08:17 -0300 (ADT) Received: from localhost (bde@localhost) by themode.com (8.12.11/8.12.10) with ESMTP id i69J8Cak039992; Fri, 9 Jul 2004 15:08:13 -0400 (EDT) Date: Fri, 9 Jul 2004 15:08:12 -0400 (EDT) From: brew@theMode.com X-X-Sender: mode@themode.com To: "Elijah O. Alcantara" Cc: pgsql-php@postgresql.org Subject: Re: wouldn't insert In-Reply-To: <1089340768.18180.9.camel@Falcon> Message-ID: References: <1089340768.18180.9.camel@Falcon> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200407/10 X-Sequence-Number: 2835 Elijah..... > There are no errors whatsoever, must be something wrong with the logic > somewhere... What I do when I can't find errors is break down the code into smaller steps and add error checking. Make the connection and check the return value. Put together the sql statement and print it. Query the database and check the return value. and so forth..... Check php.net to see some examples of error checking. On another note, if I'm only working with only one db I just connect once near the start of the script and then use that connection for the subsequent calls. brew ========================================================================== Strange Brew (brew@theMode.com) Check out my Musician's Online Database Exchange (The MODE Pages) http://www.TheMode.com ==========================================================================