I moved the error_log outside the loop and I got log message, now it
looks like the script doesn't pass through the for loop.
I wonder how can it not pass through the for loop ?? it's strange... I
didn't put any 'break' in there for sure ...
Elijah
On Mon, 2004-07-12 at 09:53, Chris wrote:
> error_log won't email you will it? It'll put it into the apache error
> log (by default) or the file you specify in your php.ini file, or if you
> have it in your script,
>
> ini_set('log_error',......)
>
> And don't separate the query, just error_log it like
>
> error_log($query2);
>
> Chris.
>
>
> -----Original Message-----
> From: pgsql-php-owner@xxxxxxxxxxxxxx
> [mailto:pgsql-php-owner@xxxxxxxxxxxxxx] On Behalf Of Elijah O. Alcantara
> Sent: Monday, July 12, 2004 11:46 AM
> To: pgsql-php@xxxxxxxxxxxxxx
> Subject: Re: [PHP] wouldn't insert
>
>
> 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@xxxxxxxxxxxxxxxx");
>
> 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@xxxxxxxxxxx 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@xxxxxxxxxxx)
> > 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
>
