On Friday 10 May 2002 13:02, Jason Soza wrote:
> If I have a MySQL field full of dates and other info, and my PHP script
> displays all this, how would I isolate the min and max in the date field?
> Like I want to print something like:
>
> Information, from 01-03-2001 through 01-03-2002
>
> If someone could give me an example or point me to the manual section that
> describes this, that'd be great. Thanks!
select min(datefield) as mindate, max(datefield) as maxdate from table;
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
QOTD:
The only easy way to tell a hamster from a gerbil is that the
gerbil has more dark meat.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
