Jump to content

Query Errors


Recommended Posts

I am trying to have this query work:

 

UPDATE actions, users SET actions.days = actions.days - TIMESTAMPDIFF(DAY, '2008-07-21 13:26:56', NOW()) WHERE TIMESTAMPDIFF(DAY, '2008-07-21 13:26:56', NOW()) >= 1 AND ((actions.fromid = '1269323825' OR actions.toid = '1269323825') AND users.user = '1269323825' AND actions.days >0 AND actions.days < 90 AND actions.type='P')

 

And when i try that, i get:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(DAY, '2008-07-21 13:26:56', NOW()) WHERE TIMESTAMPDIFF(DAY, '2008-07-21 13:26:5' at line 1

 

But i don't see a place when its wrong. Can anyone help please?

Link to comment
https://forums.phpfreaks.com/topic/115903-query-errors/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.