Re: Not to show until a certain date

[Hank]

On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson
<biz@stripped> wrote:
> On 9/28/10 8:33 PM, Chris W wrote:
>
>>
>> SELECT *
>> FROM announcements
>> WHERE announcements_expiredate > CURDATE()
>> AND announcements_postdate <= CURDATE()
>> ORDER BY announcements_expiredate ASC

Or how about something like this:

SELECT *
FROM announcements
WHERE  CURDATE() between announcements_postdate and announcements_expiredate
ORDER BY announcements_expiredate ASC