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. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php