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:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 8:59 PM
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 ->
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *

        The only easy way to tell a hamster from a gerbil is that the
        gerbil has more dark meat.

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to