Hi I am trying to get the data to display that equals the current week and year and past weeks. I am able to display the current week/year's data but not past or future.

$sql="SELECT * FROM sign WHERE WEEK(DATE)=WEEK(NOW()) AND YEAR(DATE)=YEAR(NOW())";

this is my sql statement I tried putting the >= and <= just incase I was confused but no luck.

any ideas?

thanks