mysq_query doesn't work with NOW()

Asked Feb 06 '17 at 21:07

Active Feb 06 '17 at 21:07

Viewed 26 times

For some reason this function stopped working:

mysql_query("DELETE FROM `x_servers` WHERE `end_date` <= NOW() AND `service_type` = 'timeboost' OR `end_date` <= NOW() AND `service_type` = 'vip'") or die(mysql_error());

Notably it worked fine before, so I suspect this happened after moving to mysql 5.7

Thing is that the function works if I remove the end_date <= NOW()` clause, so I think there's a problem with NOW().

Tried looking around and tried replacing it with CURDATE() and other synonyms but nothing worked. Hope that somebody can help.

asked Feb 06 '17 at 21:07

Maxim K. Magnes

What's the error that you are getting? – Darshan Mehta Feb 06 '17 at 21:10
Forgot to enable errors. Thank you! It says: PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /var/www/cron.php on line 11 Actually no. it's another line. so I suppose it doesn't give any error. – Maxim K. Magnes Feb 06 '17 at 21:12
Hi! If you try to use it in a select statement instead, (`SELECT * FROM `x_servers` WHERE `end_date` <= NOW() AND `service_type` = 'timeboost' OR `end_date` <= NOW() AND `service_type` = 'vip'`) do you get any results? And what if you only try `SELECT NOW()` - does that produce a valid date? – nibnut Feb 06 '17 at 21:13
SELECT NOW() produces a date – Maxim K. Magnes Feb 06 '17 at 21:18
The command you gave produced zero results... – Maxim K. Magnes Feb 06 '17 at 21:19
ohh snap. Sorry. The date was wrong. my bad. – Maxim K. Magnes Feb 06 '17 at 21:20
Thanks MacPrawn, and everyone else. :) – Maxim K. Magnes Feb 06 '17 at 21:20
2

Please make note of the ***big red warning*** on the [doc page](http://php.net/manual/en/function.mysql-query.php) and stop using `mysql_*`. – Sammitch Feb 06 '17 at 21:24

mysq_query doesn't work with NOW()

0 Answers0