RE: [PHP] Date Q

Thanks for the code, but I already have: $result = mysql_query("SELECT * FROM table"); And I use while ($row = mysql_fetch_array($result)) along with extract($row) to get my data. It's been my general understanding that querying twice in one script is bad. How do I incorporate your code into my script w/o querying again? -----Original Message----- From: Jason Wong [mailto:php-general@gremlins.com.hk] Sent: Thursday, May 09, 2002 8:59 PM To: php-general@lists.php.net Subject: Re: [PHP] Date Q 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. */