_expiredate, thus a logical
> error.
>
> -Original Message-
> From: Hank [mailto:hes...@gmail.com]
> Sent: Friday, October 01, 2010 4:10 PM
> To: Joerg Bruehe
> Cc: mysql@lists.mysql.com
> Subject: Re: Not to show until a certain date
>
> On Fri, Oct 1, 2010 at
Hi Hank, all!
Hank wrote:
> On Fri, Oct 1, 2010 at 2:34 PM, Joerg Bruehe wrote:
>> Hi!
>>
>>
>> Hank wrote:
>>> On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson
>>> wrote:
On 9/28/10 8:33 PM, Chris W wrote:
> SELECT *
> FROM announcements
> WHERE announcements_expir
date, and
thereafter.
But using BETWEEN, it will show on announcements_expiredate, thus a logical
error.
-Original Message-
From: Hank [mailto:hes...@gmail.com]
Sent: Friday, October 01, 2010 4:10 PM
To: Joerg Bruehe
Cc: mysql@lists.mysql.com
Subject: Re: Not to show until a certain date
On
On Fri, Oct 1, 2010 at 2:34 PM, Joerg Bruehe wrote:
> Hi!
>
>
> Hank wrote:
>> On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson
>> wrote:
>>> On 9/28/10 8:33 PM, Chris W wrote:
>>>
SELECT *
FROM announcements
WHERE announcements_expiredate > CURDATE()
AND announcements_
Hi!
Hank wrote:
> On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson
> 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
>
On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson
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
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
Thank you!
--
Patrice Olivier-Wilson
http://biz-comm.com
--
MySQL General Mailing List
For list archives: h
On 9/28/2010 10:04 AM, Patrice Olivier-Wilson wrote:
Figured it out
SELECT *
FROM announcements
WHERE announcements.announcements_expiredate >CURDATE() AND
announcements.announcements_postdate
ORDER BY announcements_expiredate ASC
I think you probably should do it like this.
SELECT *
FROM
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
