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?
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
Simon,
I just did this a matter of fact. The SELECT mysql command can do
comparisons on dates. So you would use something like this:
$today = date("Y-m-d"); # gets you today's date, see date function
on PHP.net
$qry = "SELECT * FROM `yourtable` WHERE `ExpireDate` > '$today'";
this searchs for all records where the expire date is > today,
showing everything that hasn't expired.
If you haven't checked out SMARTY, I suggest you to: smarty.php.net
There is a quick-and-dirty way to display the info without SMARTY,
but why? These days I can't understand why everyone doesn't use
SMARTY.
Good luck
_______________________________________________
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.
