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

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: wouldn't insert
Date: 2004-07-09 02:39:28
Message-ID: 1089340768.18180.9.camel@Falcon (view raw or flat)
Thread:
Lists: pgsql-php
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','$organization_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


Responses

pgsql-php by date

Next:From: Bruno Wolff IIIDate: 2004-07-09 15:27:22
Subject: Re: [PHP] Secure DB Systems - How to
Previous:From: Sarah TanembaumDate: 2004-07-08 15:49:36
Subject: Secure DB Systems - How to

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