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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
-------------------------------------------------------------------------------
Joe Stump, PHP Hacker, [EMAIL PROTECTED] -o)
http://www.miester.org http://www.care2.com /\\
"It's not enough to succeed. Everyone else must fail" -- Larry Ellison _\_V
-------------------------------------------------------------------------------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
