Re: Order by Date (Newbie)
| From: | Joe Stump | Date: | Sat, 24 Feb 2001 01:05:15 +0000 |
| Subject: | Re: Order by Date (Newbie) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-41388@lists.php.net to get a copy of this message | ||
To order by dates use SQL
select * from news order by PostDate DESC;
and then make sure that PostDate is a date or datetime - hell even an int with
a unix timestamp (aka time()) will work.
--Joe
On Fri, Feb 23, 2001 at 07:52:54PM -0500, Brian S. Drexler wrote:
> Ok, I must be missing something, but does anyone have a script that will
> order by the closest date in the future that hasn't been here yet. Did that
> make sense?
>
> Brian
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
--
-------------------------------------------------------------------------------
Joe Stump, PHP Hacker, joestump98@yahoo.com -o)
http://www.miester.org http://www.care2.com
/\\
"It's not enough to succeed. Everyone else must fail" -- Larry Ellison _\_V
-------------------------------------------------------------------------------