array from different loop results

[thebighere]

Hello All,

I can't find anything like this in the coding or general help forums, so hopefully I'm not just missing it.

I want to have different arrays created within a loop depending on one of the results from the loop.

currently im doing this:

if ($result=3) {
$mrc3 = ($mrc + $mrc33);
}

So i'd like to have an array with the separate totals of all the results=3, results=4,results=5.

Does that make sense?

I need to be able to output the totals differently depending on the $result after the loop. I did this manually because I couldn't figure out a way to use arrays, but now the number of my results has increased tenfold

Thanks very very much

[laserlight]

Sorry, I dont understand what you are trying to do.

I did this manually because I couldn't figure out a way to use arrays, but now the number of my results has increased tenfold

Provide a small and simple "manual" example that works.

[thebighere]

thank you for the quick reply

ok hopefully this helps

what i want to do is keep a tally of all the different "p" results with their mrc totals within an array. If I have 50 different "p" results, I'd need 50 arrays with "p" and the p mrc totals.

$query = "SELECT p.id,c.mrc,c.p from p,c where p.id=c.p";

while ($db->next_record()) {

if (p.id=3) {
$mrc3 = ($mrc + $mrc3);
}
if (p.id=4) {
$mrc4 = ($mrc + $mrc4);
}
}
print "result for 3";
print $mrc3;

print "result for 4";
print $mrc4;

Does that help?

[laserlight]

Consider using this query:

SELECT p.id as p_id, SUM(c.mrc) as mrc_count
	FROM p, c WHERE p.id=c.p GROUP BY p.id;

The idea here is that you want to total the c.mrc that corresponds to each p.id

[thebighere]

i apologize, that was such a silly question

i was too close to it i think

thank you so much