Upcoming event script
| From: | Andrew | Date: | Sun, 12 May 2002 07:44:04 +0000 |
| Subject: | Upcoming event script | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19136@lists.php.net to get a copy of this message | ||
I'm sorta new at php, as most of my experience is in ASP...so I need a
little help.
I am making a "next upcoming event" script. Basically, I want to be able to
put into mysql a description of the even and a date where the posting should
start, and I want to be able to make it show the most recently passed post
date. So in other words, if today is June 1 2002, and I have 3 records with
post dates of May 28, March 22, and June 13 of that year, I want it to show
the May one. How do I sort this? I know that in ASP it would be "SELECT text
FROM events WHERE date < " & now() & "SORT BY date DESC", but how do I do
it
in php?