conditions in app connect

Forum|Forum|5 years ago
January 20, 2021
2 replies
406 views

In my old site (for php 5) I used in the query: WHERE Jaartal < Year (CURDATE())-25
i am upgrading the site to php 7, but it seems that this 'Year (CURDATE())-25 ' is not good anymore?
I connect to a mysql database

This topic has been closed for replies.

BenPleysier

Community Expert

As Nancy has rightly stated, this is a PDO query. If you have a close look at the created query

You will see that you are selecting a year that is less than 0. Unless you have catered for negative years, you will not get any results.

Wappler is the DMXzone-made Dreamweaver replacement and includes the best of their powerful extensions, as well as much more!

Nancy OShea

Community Expert

This is not PHP. It's SQL.

https://learnsql.com/cookbook/how-to-get-yesterdays-date-in-mysql/

Nancy O'Shea— Product User & Community Expert

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded