update statement trouble
Posted: Thu Sep 12, 2002 4:18 am
Hi Guys, me again...
I have a problem with a update statement I'm writing..
$SQL = "update <table> SET
days = $days and used_days = $used
WHERE emp_no = $emp_no"
given that all the variables are numerics
so I get the following error:
Warning: PostgreSQL query failed: ERROR: parser: parse error at or near "" in
/var/www/html/Voffice/process.php on line 17
Connection to Table not established!
whereby line 17 is:
$results=pg_exec($conn,$sql);
I have a problem with a update statement I'm writing..
$SQL = "update <table> SET
days = $days and used_days = $used
WHERE emp_no = $emp_no"
given that all the variables are numerics
so I get the following error:
Warning: PostgreSQL query failed: ERROR: parser: parse error at or near "" in
/var/www/html/Voffice/process.php on line 17
Connection to Table not established!
whereby line 17 is:
$results=pg_exec($conn,$sql);