Results 1 to 3 of 3
Apr 26, 2004, 17:59 #1
- Join Date
- Mar 2004
- 0 Post(s)
- 0 Thread(s)
help with : equal to or less than
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.