Re: Date Q
| From: | Jason Wong | Date: | Fri, 10 May 2002 06:56:04 +0000 |
| Subject: | Re: Date Q | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-96916@lists.php.net to get a copy of this message | ||
On Friday 10 May 2002 13:14, Jason Soza wrote:
> Thanks for the code, but I already have:
> $result = mysql_query("SELECT * FROM table");
select *, min(datefield) as mindate, max(datefield) as maxdate from table;
Should work.
> 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?
Nothing inherently bad about that. After all if you can't do it in one query,
what's to stop you using two or more?
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Great American Axiom:
Some is good, more is better, too much is just right.
*/