Shoutbox

Hi.

I have now been bugged by this for the last half an hour and i cannot work out what is wrong with it. The query is:

code:

---

UPDATE `photo_sessions` SET time= 1095442814 WHERE sessionid= 'f9e4a5954785196010148e1c2567b556'

---

And i get the following error:

quote:

---

Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement., SQL state 37000 in SQLExecDirect in d:\phpportal\work\projects\image\database.php on line 30
UPDATE `photo_sessions` SET time= 1095442814 WHERE sessionid= 'f9e4a5954785196010148e1c2567b556'

---

I would usually use mysql but im having to use access for this person.

Any help would be great as im rather baffled!

Jamie

Hmm... I'm not sure, as I only use MySQL. Maybe you could try...

- enclosing the timestamp in quotes: SET time= '1095442814'
- enclosing the field name "time" in backquotes, because it might be a reserved keyword: SET `time`=

the `time` fixed the problem. I didnt think of that.

Thanks!