Re: wouldn't insert - Mailing list pgsql-php
From | Elijah O. Alcantara |
---|---|
Subject | Re: wouldn't insert |
Date | |
Msg-id | 1089598134.11624.9.camel@Falcon Whole thread Raw |
In response to | Re: wouldn't insert ("Chris" <chris@interspire.com>) |
List | pgsql-php |
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@postgresql.org > [mailto:pgsql-php-owner@postgresql.org] On Behalf Of Elijah O. Alcantara > Sent: Monday, July 12, 2004 11:46 AM > To: pgsql-php@postgresql.org > 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@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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html >