List:General Discussion« Previous MessageNext Message »
From:Patrice Olivier-Wilson Date:September 28 2010 3:04pm
Subject:Re: Not to show until a certain date
View as plain text  
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
Thread
Not to show until a certain datePatrice Olivier-Wilson28 Sep
  • Re: Not to show until a certain datePatrice Olivier-Wilson28 Sep
    • Re: Not to show until a certain dateChris W29 Sep
      • Re: Not to show until a certain datePatrice Olivier-Wilson29 Sep
        • Re: Not to show until a certain dateHank29 Sep
          • Re: Not to show until a certain dateJoerg Bruehe1 Oct
            • Re: Not to show until a certain dateHank1 Oct
              • RE: Not to show until a certain dateBMBasal1 Oct
                • Re: Not to show until a certain dateHank2 Oct
              • Re: Not to show until a certain dateJoerg Bruehe1 Oct