Mailing Lists: Apple Mailing Lists

Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Using PHP/MySQL to display data by date



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.

Many thanks.

Simon
_______________________________________________
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.




Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.