[Resolved] select statement and stumped..

[joey3002]

WHERE subj_title.date >= "'.$date.'"

what i am trying to do is have it select anything that is posted any of the following:

the day of the news post
the day before the news is posted
and the day after the news is posted

right now it selects anything on the day of the news post and day after the post..

thanks guys

[kburger]

There are some good examples here.

[kburger]

Something like this:

WHERE (subj_title.date - INTERVAL 2 DAY) <= '$date' AND (subj_title.date + INTERVAL 1 DAY) >= '$date'

There may be a cleaner query than this, but this should give you what you want. This might be a little cleaner:

WHERE subj_title.date BETWEEN ('$date' - INTERVAL 1 DAY) AND ('$date' + INTERVAL 2 DAY)

edit: something I just realized -- change it to 'INTERVAL 1 DAY' if it's a 'DATE' datatype, keep it '2 DAY' if it's a 'DATETIME' datatype.

[joey3002]

thank you once again.. you guys rock!!