Adding From While Loops

[AltarofScience]

I created the code below and it outputs the following number output:

1111111773526604115551144611337112281111221111345678910112111110035200411005110061100711008110022110034567891011411111003520041100511006110071100811002211003456789101151111100352004110051100611007110081100221100345678910112311111003520041100511006110071100811002211003456789101134

Anyways if you look at the code, I need to be able to add the values on a single colony, idcol, with the same type and subtype, btid/stid, generated as the $prod variable. buildings with the same subtype generate the same resource, in this case, several iron mines and a single copper mine are present, but there are also 9 other types of resource buildings. How do I collect on the prods which go together?

<?php
$dbhost = 'localhost:3306';
$dbuser = 'lordofth_aos';
$dbpass = 'flarge';
$dbname = 'lordofth_aos';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error connecting to mysql');
mysql_select_db($dbname);
$query="SELECT id FROM users";
$result=mysql_query($query);
$num=mysql_num_rows($result);
$i=0;
$idn=1;
while($i<$num){
$queryii="SELECT idcol FROM colony WHERE id=$idn";
$resultii=mysql_query($queryii);
$numt=mysql_num_rows($resultii);
$id=mysql_result($result, $i);
echo $id;
$ii=0;
$ibt=1;
while($ii<$numt){
$querypty="SELECT btid FROM ptypes WHERE btid=$ibt";
$resultpty=mysql_query($querypty);
$numpty=mysql_num_rows($resultpty);
$idcol=mysql_result($resultii, $ii);
echo $idcol;
$bt=0;
$btid=mysql_result($resultpty, $bt);
echo $btid;
$bte=1;
while($bt<$numpty){
$querystid="SELECT stid FROM ptypes WHERE stid=$bte";
$resultstid=mysql_query($querystid);
$numstid=mysql_num_rows($resultstid);
$st=0;
$stid=mysql_result($resultstid, $st);
echo $stid;
$ste=1;
while($st<$numstid){
$bidum=0;
$querybpid="SELECT bpid FROM blueprints WHERE btid=$btid AND stid=$stid";
$resultbpid=mysql_query($querybpid);
$numbpid=mysql_num_rows($resultbpid);
while($bidum<$numbpid){
$bidumb=0;
$bidumbg=mysql_result($resultbpid, $bidum, 'bpid');
echo $bidumbg;
$querybid="SELECT COUNT(bid) AS count, workers, efficiency 
FROM buildings
INNER JOIN blueprints ON buildings.bpid=blueprints.bpid
WHERE blueprints.btid=$btid AND blueprints.stid=$stid AND buildings.bpid=$bidumbg AND buildings.idcol=$idcol";
$resultbid=mysql_query($querybid);
$staff=mysql_result($resultbid, $bidumb, 'workers');
$effic=mysql_result($resultbid, $bidumb, 'efficiency');
$count=mysql_result($resultbid, $bidumb, 'count');
echo $staff;
echo $effic;
echo $count;
$prod=$staff*$effic*$count;
echo $prod;
$bidumb++;
$bidum++;
}
$st++;
$ste++;
}
$bt++;
$bte++;
}
$ii++;
}
$i++;
$idn++;
}
?>

[AltarofScience]

so turns out, all i had to do was set $prod=$prod+$count*$staff*$effic and then in the containing while loop create the update query. that way prod becomes the total value of all mines and then inserts into the table and then it is reset to 0 and then i can get the $prod value of the next suptype. i tested it out and its perfect.