Programming

I'm not very good at associative arrays; and working on this PHP code has got me a bit stumped. My goal is to populate a (multidimensional) associative array in a PHP while look after a MySQL query. The code fragment looks like this:

Fills like this ( print_r($info) ; ):

But is not creating the expected array indexes based on:

Because when I dump the array out of the while loop, I get the last entry (NAME1) only:

... which has got me completely confused and searching the net for examples or tutorials of how to properly populate this array based on the campaignid index has turned up blanks.

Anyone know how to do this?

The result must be full of references, which act like variables but copy around like pointers, leading to values which can mysteriously change later like you've observed.

Converting them to a string like "$THIS['val']" should prevent this I hope.

I suspect you might be able to convert those two queries into a single one with judicious use of SUM() and GROUP BY but that'll need thinking on.

---------- Post updated at 09:28 AM ---------- Previous update was at 09:19 AM ----------

Perhaps If any of those columns are ambiguous, i.e. exist in both tables you'll need to specify table.varname for them.

I tried a number of things, and when I do this:

Code:

$info = array("$campaign_row['campaignid']" => array("name" => $campaign_row['campaignname'],"booked" => (int)$campaign_row['views'], "served" => $total , "remaining" => $remaining,"weight" => (int)$campaign_row['weight'] ));

The result is a PHP error:

My mistake. You don't use single quotes inside double quotes for associative array keys, you leave the string unquoted.

---------- Post updated at 04:30 PM ---------- Previous update was at 04:27 PM ----------

You'd want to quote everything you use from $campaign_row, by the way, not just the array key. The one you convert to (int) should be fine though.

So, you think this will work?

Code:

$info = array("$campaign_row[campaignid]" => array("name" => $campaign_row['campaignname'],"booked" => (int)$campaign_row['views'], "served" => $total , "remaining" => $remaining,"weight" => (int)$campaign_row['weight'] ));

Just remove the single quotes from the first / main key?

I tried removing the single quotes; no error, but the results were the same as the original post.

These complex associative arrays are hard

I am thinking to give up on an associative array of multi-dimension for this code and move to numeric arrays; after searching the net fairly exhaustively, I've not found a similar example of a multidimensional associative array (that works).

Edit: This tutorial looks promising.

After looking at the tutorial, the problem may be as simple as this:

Code:

$info[] = blah blah blah;

As I have missed, it seems, that to update an array in PHP we need to add the "[]", so the tutorial says... so I'll try to just initialize the array and then update each time using the "[]" construct ... I hope it is that simple !