I have a db field type date: 0000-00-00
I also have a var $CurrentYear in the following format: 2006
Currently I have the following snippet in my current query:
YEAR( t1_i.i_date ) as yr
I need to add a condition into a query to match all entries that match 2006, how do I do that?
WHERE yr = ".$CurrentYear."
Sort of lost.