- 论坛徽章:
- 0
|
$db->Query("UPDATE ".CLIENT." SET status=5 WHERE status=0 AND datediff('curdate()','add_date')>=30")
我的环境是PHP5 + MYSQL5
没问题
客户环境是PHP5 + MYSQL4
报错
MySQL Info: MySQL Query Error
Script: /test/crm/index.php
Time: 2008-01-25 03:42 pm
Error: 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 '('curdate()','add_date')>=30' at line 1
Errno.: #1064
Sql: UPDATE crm_client SET status=5 WHERE status=0 AND datediff('curdate()','add_date')>=30 |
|