Hi!
Hank wrote:
On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson
b...@biz-comm.com 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
On Fri, Oct 1, 2010 at 2:34 PM, Joerg Bruehe joerg.bru...@oracle.com wrote:
Hi!
Hank wrote:
On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson
b...@biz-comm.com wrote:
On 9/28/10 8:33 PM, Chris W wrote:
SELECT *
FROM announcements
WHERE announcements_expiredate CURDATE()
AND
, 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 Fri, Oct 1
Hi Hank, all!
Hank wrote:
On Fri, Oct 1, 2010 at 2:34 PM, Joerg Bruehe joerg.bru...@oracle.com wrote:
Hi!
Hank wrote:
On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson
b...@biz-comm.com wrote:
On 9/28/10 8:33 PM, Chris W wrote:
SELECT *
FROM announcements
WHERE
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 2:34 PM, Joerg Bruehe joerg.bru...@oracle.com
wrote:
Hi!
Hank wrote:
On Wed, Sep 29, 2010
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:
On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson
b...@biz-comm.com 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
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
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
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_postdateCURDATE()
ORDER BY announcements_expiredate ASC
I think you probably should do it like this.
10 matches
Mail list logo