Re: Not to show until a certain date

[Patrice Olivier-Wilson]

On 9/28/10 10:52 AM, Patrice Olivier-Wilson wrote:
> Hi... beginner here. Working on a php page and using this
>
>
>
> $query_announcements = "SELECT * FROM announcements WHERE
> announcements.announcements_expiredate >CURDATE() ORDER BY
> announcements_expiredate ASC ";
>
>
> Client now wants the announcement NOT to show until a specific date.
>
> I have an announcements_postdate in the table. Just not sure what the
> WHERE should be to not show until that date.
>
> Thanks much,
>
>
>
Figured it out

SELECT *
FROM announcements
WHERE announcements.announcements_expiredate >CURDATE() AND 
announcements.announcements_postdate<CURDATE()
ORDER BY announcements_expiredate ASC

thx


-- 
Patrice Olivier-Wilson
http://biz-comm.com