for loop question

fnbcprog

I have this array and it is generated by a select statement:

// SELECT STATEMENT:
$getUsers = "
SELECT users.id_users,users.username,accounts.acctno,accounts.acctname,accounts.last_bal
FROM users,accounts
WHERE users.id_household = '$id_household' AND users.id_users=accounts.id_users
ORDER BY users.id_users";
$users_set = mysql_query($getUsers);

while( $arrUsers = mysql_fetch_array($users_set)) {
     $arrUserComp = $arrUsers;
}

ARRAY GENERATED BY THE SELECT QUERY

Array
(
[0] => Array
(
[0] => 1000001
[id_users] => 1000001
[1] => bharris
[username] => bharris
[2] => 5307584121
[acctno] => 5307584121
[3] => College Express
[acctname] => College Express
)

[1] => Array
    (
        [0] => 1000001
        [id_users] => 1000001
        [1] => bharris
        [username] => bharris
        [2] => 5307594121
        [acctno] => 5307594121
        [3] => Bill Payments
        [acctname] => Bill Payments
    )

[2] => Array
    (
        [0] => 1000003
        [id_users] => 1000003
        [1] => sfielden
        [username] => sfielden
        [2] => 506509878
        [acctno] => 506509878
        [3] => First Union
        [acctname] => First Union
    )

)

I WANT THE ARRAY TO LOOK LIKE THIS

Array
(
[0] => Array
(
[id_users] => user id for user 1
[username] => username
[acctno1] => account number 1
[acctname1] => name of account number 1
[last_bal1] => balance of account 1
[acctno2] => account number 2
[acctname2] => name of account number 2
[last_bal2] => balance of account 2
)

[1] => Array
    (
        [id_users] => user id for user 2
        [username] => username
        [acctno1] => account number 1
        [acctname1] => name of account number 1
        [last_bal1] => balance of account 1
    )

)

The number of [acctno] and [acctname] elements is all dependent on the number of accounts the user has. How in the heck is this done?

Then I want to be able to print out the results in table that looks like this:

| username |

| account name | account number | balance |

| However many accounts there are. |

| username |

| account name | account number | balance |

| However many accounts there are. |

I hope you can help!!!!!

saronoff

$userAccounts = array();
$userCount = 0;
while( $arrUsers = mysql_fetch_array($users_set))
{

 $userAccounts[username] = $arrUsers[username];
 $userAccounts[username][$userCount] [acctno]= $arrUsers[acctno];
 $userAccounts[username][$userCount] [acctname] = $arrUsers[acctname];
 $userAccounts[username][$userCount] [last_bal] = $arrUsers[last_bal];
 $userCount++;

}

foreach(array_keys($userAccounts) as $username)
{
print "| $username |";
print "------------------------------------------------------------------";
foreach(array_keys($userAccounts[$username]) as $accountIndex)
{
print "| $userAccounts[$username][$accountIndex][acctname] |";
print " $userAccounts[$username][$accountIndex][acctno] |";
print " $userAccounts[$username][$accountIndex][last_bal] |";
print "------------------------------------------------------------------";
}
}

That should do it. You may need to do some tweaking of the loops but it should work.

fnbcprog

when I check the array using <pre> and print the array the only think that gets printed is this:

Array
(
[username] => bharris
)

fnbcprog

This is the array:

Array
(
[1000001] => Array
(
[id_users] => 1000001
[username] => bdoe

      [0] => Array
      (
            [acctno] => 123456789
            [acctname] => Something
            [last_bal] => 500
      )

      [1] => Array
      (
            [acctno] => 123654789
            [acctname] => Something2
            [last_bal] => 300
      )
 )

 [1000003] => Array
 (
      [id_users] => 1000003
      [username] => jdoe

      [2] => Array
      (
            [acctno] => 123654987
            [acctname] => Something3
            [last_bal] => 200
      )
 )

)

	
foreach(array_keys($userAcctComp) as $id_users) {
		echo $userAcctComp[$id_users][username];
		echo "<br>";

	foreach(array_keys($userAcctComp[$id_users]) as $arrAccount) {
		$acctno =  $userAcctComp[$id_users][$arrAccount][acctno];
		$acctname = $userAcctComp[$id_users][$arrAccount][acctname];
		print ("$acctno = $acctname");
	}
}

When i execute this on the website it returns this:

bdoe
1 = 1b = b123456789= Something123654789= Something2jdoe
1 = 1s = s123654987= Something 3

WHAT ARE THOSE THINS IN FRONT OF EACH ACCT NUMBER????

saronoff

The code I presented had a small bug in it. Being that you didn't, or I didn't, declare the $userAccounts[username] as an array the letters you're seeing are the first letter of the username.

So....Things need to be changed a bit:

$userAccounts[username] = array();
$userAccounts[username][username] = $arrUsers[username];

$userAccounts[username][$userCount] = array();

You might be able to just do this:
$userAccounts[username][$userCount] = array("acctno"=>"$arrUsers[acctno]", "acctname"=>"$arrUsers[acctname]", "last_bal" =>"$arrUsers[last_bal]");

But this should work too:

$userAccounts[username][$userCount] [acctno]= $arrUsers[acctno];
$userAccounts[username][$userCount] [acctname] = $arrUsers[acctname];
$userAccounts[username][$userCount] [last_bal] = $arrUsers[last_bal];

$userCount++;

Then change this line print "| $username |";
to be:

print "| $userAccounts[$username][username] |";

Also, instead of echoing out array contents use "print_r". It will dump the entire array and you can see the contents. Thing should work a bit better now.

Weedpacket

Originally posted by fnbcprog
I WANT THE ARRAY TO LOOK LIKE THIS

This part is easy; use mysql_fetch_assoc() instead of mysql_fetch_array().