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);
update statement trouble
Moderator: General Moderators
- Love_Daddy
- Forum Commoner
- Posts: 61
- Joined: Wed Jul 10, 2002 6:55 am
- Location: South Africa
- Contact:
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
- Love_Daddy
- Forum Commoner
- Posts: 61
- Joined: Wed Jul 10, 2002 6:55 am
- Location: South Africa
- Contact:
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
- Love_Daddy
- Forum Commoner
- Posts: 61
- Joined: Wed Jul 10, 2002 6:55 am
- Location: South Africa
- Contact: