quicker query?
| From: | Michael Roark | Date: | Sun, 06 May 2001 03:27:49 +0000 |
| Subject: | quicker query? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-51583@lists.php.net to get a copy of this message | ||
Is there a faster (better) way to do the following:
if ($result) {
for ($cluster=1;$cluster<200;$cluster++) {
for($galaxy=1;$galaxy<26;$galaxy++) {
$sql="insert into galaxy select avg(cluster) as gcluster,sum(size) as gsize,sum(score) as
gscore,avg(galaxy) as ggalaxy from universe where cluster='$cluster' and
galaxy='$galaxy'";
$result=db_query($sql);
Thanks
Michael