help with : equal to or less than

[sheephrdr]

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

[swampBoogie]

Past and current records

SELECT * 
FROM sign 
WHERE ( WEEK(DATE) <= WEEK(NOW()) AND YEAR(DATE)=YEAR(NOW()))
  or year(date) < year(now())

Future records

SELECT * 
FROM sign 
WHERE ( WEEK(DATE) > WEEK(NOW()) AND YEAR(DATE)=YEAR(NOW()))
  or year(date) >= year(now())

Why not

select * from sign where date <= current_date

?

[sheephrdr]

Ill try these after work, select from current date alone wont work because I want the data to appear for the whole week not just the day.