Update in Postgres
Posted: Wed Aug 28, 2002 5:04 am
Hi Guys,
I'm trying to write an update query in PHP using progres..
$sql="UPDATE users SET
name='$name',
surname='$surname',
tel_no='$telno',
cel_no=$celno
WHERE emp_no=$empno";
$results=pg_exec($connection,$sql);
But it doesn't work.
What would be a problem?
I get this msg:
Warning: PostgreSQL query failed: ERROR: parser:
parse error at or near "" in /var/www/html/shakanet/update.php on line 20
Connection to Table not established!
Of which line 20 is:
$results=pg_exec($connection,$sql);
Thanks
I'm trying to write an update query in PHP using progres..
$sql="UPDATE users SET
name='$name',
surname='$surname',
tel_no='$telno',
cel_no=$celno
WHERE emp_no=$empno";
$results=pg_exec($connection,$sql);
But it doesn't work.
What would be a problem?
I get this msg:
Warning: PostgreSQL query failed: ERROR: parser:
parse error at or near "" in /var/www/html/shakanet/update.php on line 20
Connection to Table not established!
Of which line 20 is:
$results=pg_exec($connection,$sql);
Thanks