Error updating in Access with PHP
| From: | George Pitcher | Date: | Mon, 26 May 2003 10:18:38 +0000 |
| Subject: | Error updating in Access with PHP | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28043@lists.php.net to get a copy of this message | ||
Hi,
I'm working on an Access/PHP site and am having a problem updating a record.
I get a SQL syntax error.
This is the SQL query being sent:
update Extracts SET (Expiry_date=27/05/2003, Production='Heron') WHERE
ID=134
I've tried enclosing the date variable in ' ' but with no different result.
Can anyone point me in the right direction? I'm fairly sure its the date
format that's creating the problem.
Cheers
George
===
George Pitcher
HERON Technical Manager
Ingenta plc
23-38 Hythe Bridge Street, Oxford, OX1 2ET
T +44 (0)1865 799051 direct
T +44 (0)1865 799000 switchboard
F +44 (0)1865 799134
E george.pitcher@ingenta.com
www.ingenta.com
Ingenta: Empowering the exchange of academic and professional content
online.