conditions in app connect

2 replies
419 views
Translate

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 is closed to new replies. Start a new post to keep the conversation going.

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.

Translate

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/

Translate

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.