i cant insert or update a record in postgres using PHP

[Bluebird]

hi all

i am trying to update a record , which is in postgres databse using PHP, it's not showing any error , but records are not updated.
summary of the code given below
<?php
$db=pg_connect('user=postgres dbname=crm');
$qry="update Customer SET dispostion='Rejected' where phone='123456';
$qry_res=pg_query($qry);
print 'Affectd Rows '.pg_affected_rows($qry);

.......
?>

i queried the Database , updation not reflected .

any error in coding ??

any help
Thanks
Bluebird

[phpmaet]

Hi
check your connection details.

Try this code,

[PHP]<?
// Connect to the Postgres Database

$conn = pg_Connect("localhost", "5432", "", "", "test");
if (!$conn) {echo "Connection error occurred.\n"; exit;}

// Insert the form values into the database

$result = pg_Exec($conn,"INSERT INTO contacts VALUES ('$Name',
'$Address','$City','$Email');");

// Select the values from database

$result = pg_Exec($conn,"SELECT cid, name, address, city, email FROM contacts WHERE cid = $ID");


// Update the form values into the database

$result = pg_Exec($conn,"UPDATE contacts SET name='$Name',
address='$Address', city='$City',email='$Email' WHERE cid='$ID'");


if (!$result) {echo "Query Error.\n"; exit;}

pg_FreeResult($result);

// Close the connection
pg_Close($conn);
?>[/PHP]

Thanks