Skip site navigation (1) Skip section navigation (2)

Re: wouldn't insert

From: "Elijah O(dot) Alcantara" <elijah(at)asti(dot)dost(dot)gov(dot)ph>
To: pgsql-php(at)postgresql(dot)org
Subject: Re: wouldn't insert
Date: 2004-07-12 02:16:06
Message-ID: 1089598566.11624.12.camel@Falcon (view raw or flat)
Thread:
Lists: pgsql-php
Bingo! no wonder it can't push through the loop, there wasn't any
results in the first place at the first query. Error_log()'s very useful
=)

Thanks,
Elijah

On Mon, 2004-07-12 at 09:45, Elijah O. Alcantara wrote:
> 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(at)asti(dot)dost(dot)gov(dot)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(at)theMode(dot)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(at)theMode(dot)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
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html


In response to

Responses

pgsql-php by date

Next:From: Scott MarloweDate: 2004-07-12 02:18:25
Subject: Re: wouldn't insert
Previous:From: Elijah O. AlcantaraDate: 2004-07-12 02:08:55
Subject: Re: wouldn't insert

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group