dynamic tables from multiple files

thinsoapy

I have a very simple form where a user can select ONE store number from a drop-down list, and MULTIPLE weeks from another drop-down list (using WeekNumber[ ] to create an array). In the php script that handles the form, it it supposed to create a table that displays the data from text files that correspond to week numbers previously selected, with each week's data in a new row (I'm using foreach). No matter how many weeks I select, the script only creates a table that has one row for the last week selected - and no errors reported.

I think it's a looping problem, but I can find no examples very close to this anywhere on the net.

Can someone look at my code?

amcgrath

"Can someone look at my code?" ... well, it would help if you actually posted it....

thinsoapy

Here it is: (sorry)

// start the table header row
print ("<table border=\"1\">" . trow(tdb("Week") . tdb("Sales") . tdb("Budget") . tdb("Comp")));
/ take each week # selected from form (select multiple - as an array), one at a time, open a corresponding delimited text file, explode the data from file into a new temp array and create new variables from the temp array. /
foreach ($WeekNumber as $aValue); {
$Selection = Week . " " . $aValue;
$TheFile = "$StoreNumber/$Selection.txt";
$Open = fopen ($TheFile, "r+");
$aLine = fgets ($Open, 1024);
$aTempArray = explode ("\t", $aLine);
$Week[] = $aTempArray[0];
$Sales[] = $aTempArray[1];
$Budget[] = $aTempArray[2];
$Comp = ((($Budget[] - $Sales[]) / $Budget[]) 100);
/ after variables are defined, put them into a new row in the table, then go back
and get the data from the next file. what is actually happening is that only the
data from the last week selected is actually making it into the table. */
print (trow(tdl($Week) . tdn($Sales) . tdn($Budget) . tdn($Comp)));
}
print ("</table>");

thinsoapy

Now that I know how array_walk works, there is no problem...