pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris <chris@interspire.com>
To: 'Elijah O. Alcantara' <elijah@asti.dost.gov.ph>
To: pgsql-php@postgresql.org
Subject: Re: wouldn't insert
Date: Mon, 12 Jul 2004 09:42:23 +1000
Message-ID: <001601c467a0$be3291f0$0d00a8c0@chris> (raw)
In-Reply-To: <1089340768.18180.9.camel@Falcon>

Hey,

echo out $query2 before it runs, try a few in psql and it should tell
you what the error is....

Chris.

-----Original Message-----
From: pgsql-php-owner@postgresql.org
[mailto:pgsql-php-owner@postgresql.org] On Behalf Of Elijah O. Alcantara
Sent: Friday, July 09, 2004 12:39 PM
To: pgsql-php@postgresql.org
Subject: [PHP] wouldn't insert


Hi again,

Can someone help me out on this? the function I quoted below is supposed
to restore the values from table temp_contactinfo to contactinfo. But
it's not inserting to the contactinfo table... 

There are no errors whatsoever, must be something wrong with the logic
somewhere... 



> function restore_contactinfo($connectGovPH, $ctrl_no) {
> 
> $query_clear = "delete from contactinfo where ctrl_no = '$ctrl_no'"; 
> pg_Exec($connectGovPH,$query_clear);
> 
> $query = "select * from temp_contactinfo where ctrl_no = '$ctrl_no'"; 
> $result = pg_Exec($connectGovPH,$query); $num = pg_NumRows($result);
> 
> 
> for($i=0;$i<$num;$i++) {
>         $row = pg_Fetch_Object($result,$i);
>         $category = $row->category;
>         $contact_no = $row->contact_no;
>         $contact_name = $row->contact_name;
>         $organization_name = $row->organization_name;
>         $address = $row->address;
>         $telephone = $row->telephone;
>         $fax = $row->fax;
>         $email = $row->email;
> 
>         $query2 = "INSERT INTO contactinfo 
>
VALUES('$ctrl_no','$category','$contact_no','$contact_name','$organizati
on_name','$address','$telephone','$fax','$email')";
>         pg_Exec($connectGovPH,$query2);
>         
>         $query3 = "DELETE FROM temp_contactinfo WHERE ctrl_no = 
> '$ctrl_no' AND category = '$category' AND contact_no = '$contact_no'";
>         pg_Exec($connectGovPH,$query3);
> 	}
> }

I've searched and searched but couldn't find anything wrong with the
code =( 


Elijah


---------------------------(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




view thread (8+ messages)  latest in thread

Message-ID: <001601c467a0$be3291f0$0d00a8c0@chris>
Permalink:  ../001601c467a0$be3291f0$0d00a8c0@chris/
Also on:    postgresql.org/message-id/001601c467a0$be3291f0$0d00a8c0@chris

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: chris@interspire.com, elijah@asti.dost.gov.ph
  Subject: Re: wouldn't insert
  In-Reply-To: <001601c467a0$be3291f0$0d00a8c0@chris>
  References: <1089340768.18180.9.camel@Falcon> <001601c467a0$be3291f0$0d00a8c0@chris>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox