newbie foreach problems

[slightlyeskew]

Hi guys, feeling especially newb today.

Here's my problem:

I'm using TCPDF to produce a PDF file that contains 3 columns, first name, last name, and an integer associated with each person.

My tables in mysql, however, are not ideally coordinated for this combo.

the code:

//assume $db connection and $pdf creation

$pdf->Multicell(30,12,'Last',0,'L',1,0,'','',true); //labelling columns here.
$pdf->Multicell(30,12,'First',0,'L',1,0,'','',true);
$pdf->Multicell(30,12,'Number of Shares',0,'R',1,1,'','',true);


$totalIDs = $db->query("SELECT First_Name,Last_Name,ShareholderID FROM ShareholderNames");
$idArray = $totalIDs->fetchAll();

unset($idArray[0]);unset($idArray[167]); //the unsets are fine.

$numberIDs = count($idArray);

$transactions = $db->query("SELECT Source_Shareholder,Destination_Shareholder,Number_Of_Shares FROM TransactionHistory ORDER BY TransactionID");

$transactionArray = $transactions->fetchAll();
$numberofTransactions = count($transactionArray);

$entryCounter = 0;

while($entryCounter < $numberofTransactions)//initially gets all of the shareholders
{
	$source = $transactionArray[$entryCounter][0];$dest = $transactionArray[$entryCounter][1];$shares = $transactionArray[$entryCounter][2];
	if($source != 0 && ($source != 99999))
	{
	$summaryArray[$source]['shares'] -= $shares;	
	}
	if($dest != 0 && ($dest != 99999))
	{
	$summaryArray[$dest]['shares'] += $shares;
	}

$entryCounter++; //this all works fine.
}
//okay so summary Array works

foreach($summaryArray as $characterID => $shareArray)$smallerArray)
{

//HERE is the crap that's driving me crazy!!!	
//so $characterID gives me the ID numbers, but I need to access the next array below it
//I tried to do ($summaryArray as $characterID => $shareArray as $shares)
//but it didn't work.
//The array is formatted as $summaryArray[ID number][number of shares]
//I also have $idArray = [key][last name][first name][ID number].
//So i need to take the ID number from share array and use it to grab the names
//and then take the Number of shares and associate it with the ID number
//to produce three columns, last name, first name, number of shares.	


$pdf->Multicell(30,12,$last,0,'L',1,0,'','',true);
$pdf->Multicell(30,12,$first,0,'L',1,0,'','',true);
$pdf->Multicell(30,12,$shares,0,'R',1,1,'','',true);
}

$pdf->Output('CurrentShareholders', 'F');

?>

Any help at the proper way to format this to get my desired result would be GREATLY appreciated. Thanks in advance for your time and knowledge.

-slight

[anakadote]

There's definitely something [slightly] askew in this line:

foreach($summaryArray as $characterID => $shareArray)$smallerArray) 

Can you post the output of print_r($summaryArray)?

[jgetner]

ia'm very confused where are you getting your $smallarray() what is the purpose of $smallarray()?.

as this will help us better understand your code and your problem and quickly get you a solution.

but you could do a double loop with foreach(){foreach(){some id or something}}

[slightlyeskew]

I apologize, that line should be

foreach($summaryArray as $characterID)

The line you posted was something I attempted to try and be able to access both the key and the second array contained inside $summaryArray

print_r($summaryArray) yields:

Array ( [1] => Array ( [shares] => 24967 ) [2] => Array ( [shares] => 4699 ) [3] => Array ( [shares] => 46094 ) [4] => Array ( [shares] => 647989 ) [5] => Array ( [shares] => 30369 ) [6] => Array ( [shares] => 17165 ) [7] => Array ( [shares] => 34238 ) [10] => Array ( [shares] => 0 ) [11] => Array ( [shares] => 30598 ) [13] => Array ( [shares] => 0 ) [12] => Array ( [shares] => 0 ) [99998] => Array ( [shares] => 410147 ) [18] => Array ( [shares] => 0 ) [20] => Array ( [shares] => 0 ) [23] => Array ( [shares] => 0 ) [22] => Array ( [shares] => 14882 ) [25] => Array ( [shares] => 0 ) [26] => Array ( [shares] => 0 ) [27] => Array ( [shares] => 0 ) [30] => Array ( [shares] => 0 ) [34] => Array ( [shares] => 0 ) [35] => Array ( [shares] => 0 ) [36] => Array ( [shares] => 0 ) [43] => Array ( [shares] => 0 ) [45] => Array ( [shares] => 0 ) [42] => Array ( [shares] => 0 ) [44] => Array ( [shares] => 0 ) [29] => Array ( [shares] => 10860 ) [39] => Array ( [shares] => 0 ) [49] => Array ( [shares] => 0 ) [52] => Array ( [shares] => 0 ) [46] => Array ( [shares] => 0 ) [56] => Array ( [shares] => 0 ) [53] => Array ( [shares] => 0 ) [62] => Array ( [shares] => 0 ) [81] => Array ( [shares] => 2589 ) [82] => Array ( [shares] => 3339 ) [41] => Array ( [shares] => 0 ) [75] => Array ( [shares] => 0 ) [85] => Array ( [shares] => 1414 ) [86] => Array ( [shares] => 0 ) [89] => Array ( [shares] => 0 ) [87] => Array ( [shares] => 655 ) [47] => Array ( [shares] => 0 ) [92] => Array ( [shares] => 100 ) [88] => Array ( [shares] => 945 ) [95] => Array ( [shares] => 0 ) [97] => Array ( [shares] => 781 ) [100] => Array ( [shares] => 97 ) [94] => Array ( [shares] => 430 ) [84] => Array ( [shares] => 0 ) [114] => Array ( [shares] => 1090 ) [128] => Array ( [shares] => 1154 ) [106] => Array ( [shares] => 928 ) [123] => Array ( [shares] => 75 ) [119] => Array ( [shares] => 1395 ) [105] => Array ( [shares] => 9597 ) [124] => Array ( [shares] => 47 ) [110] => Array ( [shares] => 1103 ) [120] => Array ( [shares] => 1358 ) [126] => Array ( [shares] => 946 ) [125] => Array ( [shares] => 0 ) [118] => Array ( [shares] => 1047 ) [121] => Array ( [shares] => 934 ) [117] => Array ( [shares] => 0 ) [130] => Array ( [shares] => 638 ) [109] => Array ( [shares] => 85 ) [115] => Array ( [shares] => 685 ) [127] => Array ( [shares] => 1085 ) [113] => Array ( [shares] => 0 ) [111] => Array ( [shares] => 685 ) [116] => Array ( [shares] => 498 ) [122] => Array ( [shares] => 281 ) [112] => Array ( [shares] => 685 ) [144] => Array ( [shares] => 1338 ) [145] => Array ( [shares] => 0 ) [153] => Array ( [shares] => 952 ) [154] => Array ( [shares] => 2861 ) [132] => Array ( [shares] => 3 ) [138] => Array ( [shares] => 1203 ) [140] => Array ( [shares] => 733 ) [142] => Array ( [shares] => 1524 ) [146] => Array ( [shares] => 60 ) [135] => Array ( [shares] => 746 ) [131] => Array ( [shares] => 0 ) [147] => Array ( [shares] => 813 ) [150] => Array ( [shares] => 1479 ) [152] => Array ( [shares] => 1945 ) [129] => Array ( [shares] => 0 ) [143] => Array ( [shares] => 934 ) [159] => Array ( [shares] => 0 ) [161] => Array ( [shares] => 264 ) [157] => Array ( [shares] => 125 ) [28] => Array ( [shares] => 100 ) [137] => Array ( [shares] => 910 ) [148] => Array ( [shares] => 550 ) [139] => Array ( [shares] => 373 ) [162] => Array ( [shares] => 225 ) [158] => Array ( [shares] => 525 ) [151] => Array ( [shares] => 50 ) [141] => Array ( [shares] => 679 ) [155] => Array ( [shares] => 521 ) [133] => Array ( [shares] => 0 ) [156] => Array ( [shares] => 550 ) [160] => Array ( [shares] => 0 ) [164] => Array ( [shares] => 71 ) [170] => Array ( [shares] => 64 ) [171] => Array ( [shares] => 266 ) [169] => Array ( [shares] => 168 ) [183] => Array ( [shares] => 256 ) [173] => Array ( [shares] => 434 ) [174] => Array ( [shares] => 0 ) [188] => Array ( [shares] => 444 ) [192] => Array ( [shares] => 0 ) [195] => Array ( [shares] => 2385 ) [193] => Array ( [shares] => 2772 ) [180] => Array ( [shares] => 253 ) [181] => Array ( [shares] => 0 ) [191] => Array ( [shares] => 211 ) [194] => Array ( [shares] => 129 ) [186] => Array ( [shares] => 256 ) [187] => Array ( [shares] => 182 ) [178] => Array ( [shares] => 322 ) [166] => Array ( [shares] => 200 ) [190] => Array ( [shares] => 0 ) [196] => Array ( [shares] => 0 ) [204] => Array ( [shares] => 79 ) [201] => Array ( [shares] => 128 ) [203] => Array ( [shares] => 0 ) [200] => Array ( [shares] => 134 ) [209] => Array ( [shares] => 0 ) [198] => Array ( [shares] => 150 ) [210] => Array ( [shares] => 35 ) [168] => Array ( [shares] => 174 ) [206] => Array ( [shares] => 0 ) [182] => Array ( [shares] => 100 ) [214] => Array ( [shares] => 149 ) [216] => Array ( [shares] => 111 ) [217] => Array ( [shares] => 36 ) [215] => Array ( [shares] => 38 ) [212] => Array ( [shares] => 0 ) [149] => Array ( [shares] => -60 ) [185] => Array ( [shares] => 0 ) [184] => Array ( [shares] => 100 ) [220] => Array ( [shares] => 20 ) [221] => Array ( [shares] => 8 ) [199] => Array ( [shares] => 72 ) [222] => Array ( [shares] => 12 ) [240] => Array ( [shares] => 115 ) )

This represents both the ID codes of each shareholder and the number of shares

print_r ($idArray) yields an array of the form

Array ( [1] => Array ( [0] => slightly [1] => eskew [2] => 1 ) ... with 177 total entries.

where [0] is first, [1] last, and [2] is ID number

(I would post the whole thing but it has peoples full names in it.)

Thanks for your time!

[slightlyeskew]

Is there anyway I could clean this up to make it clearer? I can't seem to figure out how to edit my previous post to clear it up.