getting associative array to output correct including missing value

bouton · #1 20-Sep-2006, 08:02

I have an associative array that looks like

Code:

Array
(
    [0] => Array
        (
            [graph_user_hpcx_last_name] => Smith
            [graph_user_hpcx_Accounting_Year] => 2006
            [graph_user_hpcx_Accounting_Month] => 6
            [graph_user_hpcx_AllocationUnits] => 104
        )

    [1] => Array
        (
            [graph_user_hpcx_last_name] => Brown
            [graph_user_hpcx_Accounting_Year] => 2006
            [graph_user_hpcx_Accounting_Month] => 6
            [graph_user_hpcx_AllocationUnits] => 316
        )
    [2] => Array
        (
            [graph_user_hpcx_last_name] => Smith
            [graph_user_hpcx_Accounting_Year] => 2006
            [graph_user_hpcx_Accounting_Month] => 7
            [graph_user_hpcx_AllocationUnits] => 310
        )
    [3] => Array
        (
            [graph_user_hpcx_last_name] => Doe
            [graph_user_hpcx_Accounting_Year] => 2006
            [graph_user_hpcx_Accounting_Month] => 7
            [graph_user_hpcx_AllocationUnits] => 36
        )

What I'm trying to do is come up with a loop (to use in a graphing program XML-SWF Charts) which will produce a table like
June July
Smith 104 310
Brown 316 0
Doe 0 36

which is a listing like

begin graph_user_hpcx_last_name:
Smith
Brown
Doe
end graph_user_hpcx_last_name:

begin graph_user_hpcx_Accounting_Month = 6
June
104
316
0
end_graph_user_hpcx_Accounting_Month = 6

begin graph_user_hpcx_Accounting_Month = 7
July
310
0
36
end_graph_user_hpcx_Accounting_Month = 7
I've tried to make an array of all the last names

PHP Code:


$last_name_array = array();
foreach ($results as $key => $value) {        
    $last_name_array[]=$value[graph_user_hpcx_last_name];
}
sort($last_name_array);
$last_name_array=array_unique($last_name_array);

then looping through all my results to see if it matches a name, if so print the units, if not print 0 but I get way two sets for each name (cause of the 6 and 7 month)

PHP Code:


foreach ($last_name_array as $key => $value) {            
         foreach ($results as $key => $value1) {   
             if  ($value == $value1[graph_user_hpcx_last_name])  {
                if ($value1[graph_user_hpcx_Accounting_Year]== 2006 && $value1[graph_user_hpcx_Accounting_Month] == 6) {
              echo "$value1[graph_user_hpcx_AllocationUnits]<br />\n";
                }  else {
                echo "0";
               }
             }
         }
    }

Any suggestions on how best to get this? Been reading all I can and am still stumped!

TurboPT · #2 28-Sep-2006, 20:09

Are you still having trouble getting the loop to work right?

bouton · #3 29-Sep-2006, 02:42

never figured it out- so went in and set the column in the database to 0

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Bit stuffing	agnostos	C Programming Language	17	12-Sep-2006 20:10
Need help deleting the last element in the array	headphone69	C++ Forum	2	15-Mar-2006 19:31
C++ PhoneBook	marita	C++ Forum	46	12-Jun-2005 12:10
template comiling problems - need expert debugger!	crq	C++ Forum	1	01-Feb-2005 21:26
using vector or array	oshiotse	C++ Forum	4	16-Apr-2004 10:59

getting associative array to output correct including missing value

Re: getting associative array to output correct including missing value

Re: getting associative array to output correct including missing value