Welcome Guest, Not a member yet? Register   Sign In
How to show date rows equals current date?


What we are doing is putting together a string that should be converted to a date value in order for it to be compared to the current date value.

Basically what select DATE(concat(year,'-',month,'-',multiple)) should give you is (1st record)... '2018-07-30'

The error message that you received is stating that the year field does not exist. Is that right? If so, what is the actual field name?

The day column (multiple) is a little bit tricky. We will need to put a condition in place to handle how it is used in the concat function.

Messages In This Thread
RE: How to show date rows equals current date? - by php_rocs - 03-03-2019, 10:09 PM

Theme © iAndrew 2016 - Forum software by © MyBB