how to drag 6 april (last year) to 5 april (this year) from a php mysql database.?

Jonathan

New member
i have a field called "r" and r contains date in the format 0000-00-00. i need to query the database and echo all entried that fall within this tax year (UK) so it would be april 6th last year till april 5th this year.
is their a way of doing this without manually changing the dates e.g. so using the YEAR(CURDATE()) or something similar? thanks in advance. First answer to work get best answer
 
Back
Top