Re: too many records

From: 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

« previous php.db (#426) next »