Re: too many records
| From: | Zak Greant | Date: | Thu, 15 Jun 2000 02:06:02 +0000 |
| Subject: | Re: too many records | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-426@lists.php.net to get a copy of this message | ||
At 06:21 PM 6/14/00 -0700, Rasmus Lerdorf wrote:
That's not a very efficient way to do it. Let the database do the work for you. You can loop through: select * from verbscom where YEAR(date)=2000 and MONTH(date)=$i Or, you could probably even do it all in a single query by using a group by month(date) clause. -Rasmus<sigh> I hate it when Rasmus answers the same questions that I answer! ;) Zak Greant Creative Director Nucleus Information Service Inc. "I am rather like a mosquito in a nudist camp: I know what I ought to do, but I don't know where to begin." - Stephen Bayne