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 4BE97D1B1B0 for ; Sun, 11 Jul 2004 22:45:40 -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 53936-09 for ; Mon, 12 Jul 2004 01:45:39 +0000 (GMT) Received: from kimi.asti.dost.gov.ph (kimi.asti.dost.gov.ph [202.90.128.26]) by svr1.postgresql.org (Postfix) with ESMTP id 96635D1B1AB for ; Sun, 11 Jul 2004 22:45:34 -0300 (ADT) Received: from falcon.asti.dost.gov.ph (unknown [10.10.5.200]) by kimi.asti.dost.gov.ph (Postfix) with ESMTP id 2D7AA2381A5 for ; Mon, 12 Jul 2004 09:24:16 +0800 (PHT) Subject: Re: wouldn't insert From: "Elijah O. Alcantara" To: pgsql-php@postgresql.org In-Reply-To: References: <1089340768.18180.9.camel@Falcon> Content-Type: text/plain Message-Id: <1089596732.11624.3.camel@Falcon> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Mon, 12 Jul 2004 09:45:33 +0800 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/12 X-Sequence-Number: 2837 I tried using error_log() but never got any emails... error_log("This is query2 inserting $ctrl_no $category $contact_no $organization_name $address $telephone $fax $email", 1, "elijah@asti.dost.gov.ph"); looks like it never went in the for loop, somethings wrong... Thanks for the advice, Elijah On Sat, 2004-07-10 at 03:08, brew@theMode.com wrote: > 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 > ========================================================================== > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match