i am looking for a way to check if a serie of record from my DB is in a periode of dates.
for example i want to select all records between 01-01-01 and 31-12-01
does anybody know how to code this in PHP ????
thanx
use the BETWEEN SQL keyword, like this:
SELECT dates FROM mytable WHERE dates BETWEEN '2002-01-20' AND '2002-09-20'