im having the table name fiscalyear
These are the columns
- id(auto increment)
- begin (financial year begin date)
- end (financial year end date)
active (either 0(open) or 1(closed))
begin column consists dates like 2012-01-01
- end column consists dates like 2012-12-31
i want to get the financial year begin and end date
These are the conditions
- which is open i.e 0,
- also it should be the last inserted.
Here is the query i tried please update my query according to my conditions
SELECT BEGIN,END FROM fiscalyear WHERE active='0'
ONE MORE THING IS THAT..
- I want to print the selected dates in format 2012-13 on the screen using PHP