Re: Using PHP/MySQL to display data by date

• Subject: Re: Using PHP/MySQL to display data by date
• From: Yueh-Chin Ma <email@hidden>
• Date: Wed, 23 Jun 2004 00:34:34 -0400

Thanks Tim for your note. It works for me.

Thanks,
Yueh-Chin

On 22-Jun-04, at 12:20 PM, Timothy Binder wrote:

On Jun 21, 2004, at 6:37 PM, Simon Birch wrote:

Could someone recommend a good resource, either online or a book, that explains how to display data on a web page according to the current date using PHP/MySQL?

For example, suppose I have the following data:

Name Info StartDate EndDate
Item 1 Description 1 2004-06-21 2004-06-22
Item 2 Description 2 2004-06-23 2004-06-24
Item 3 Description 3 2004-06-23 2004-06-26

Today is June 21, 2004. I want my web page to display Item 1 but not Items 2 and 3. On June 23, my page displays Items 2 and 3 but Item 1 has "expired" and is no longer displayed.

I've really spent some time searching for than answer online, including the PHP and MySQL manuals, but I can't find precisely what I'm looking for. Be gentle if I'm an idiot and have overlooked something obvious.

I like to keep things as straightforward as possible. Assuming your columns are named as above and are DATE columns, not DATETIME, the following statement will select only those rows within your range. Note that the comparison checks *both* starting date and ending date.

SELECT * FROM tablename WHERE CURDATE() BETWEEN StartDate AND EndDate

From the MySQL pages:

CURDATE() Returns the current date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in a string or numeric context.
mysql> SELECT CURDATE();
-> '1997-12-15'
mysql> SELECT CURDATE() + 0;
-> 19971215

Note that CURRENT_DATE and CURRENT_DATE() are synonymous with CURDATE().

A write up on BETWEEN is at <http://dev.mysql.com/doc/maxdb/en/85/16665bc71b11d2a97100a0c9449261/ content.htm>

Hope This Helps,
Tim
--
Timothy Binder, President
Philadelphia Science Fiction Society <http://www.psfs.org/>
Upcoming Programming: Hugo Panel, Mark Wolverton
_______________________________________________
web-development mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/web-development
Do not post admin requests to the list. They will be ignored.

_______________________________________________
web-development mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/web-development
Do not post admin requests to the list. They will be ignored.

• Prev by Date: Re: Newbie-updates to php?
• Next by Date: PHP rebuild with GD
• Previous by thread: Re: Using PHP/MySQL to display data by date
• Next by thread: RE: Using PHP/MySQL to display data by date
• Index(es):
  • Date
  • Thread