PHP - Combining 2 Arrays And Sorting Them And Outputting

Hey,

I have the following two arrays, of which I want to use bits of each from to get another array.
Array 1:
Array
(
    [0] => Array
        (
            [shop_id] => 1
            [shop_name] => Aldi
            [shop_district] => 6
        )

    [1] => Array
        (
            [shop_id] => 2
            [shop_name] => Greggs
            [shop_district] => 6
        )

    [2] => Array
        (
            [shop_id] => 3
            [shop_name] => Tesco
            [shop_district] => 6
        )

    [3] => Array
        (
            [shop_id] => 4
            [shop_name] => Morrisons
            [shop_district] => 6
        )

    [4] => Array
        (
            [shop_id] => 5
            [shop_name] => Ryman
            [shop_district] => 6
        )

    [5] => Array
        (
            [shop_id] => 6
            [shop_name] => Boots
            [shop_district] => 6
        )

    [6] => Array
        (
            [shop_id] => 7
            [shop_name] => Superdrug
            [shop_district] => 6
        )

    [7] => Array
        (
            [shop_id] => 8
            [shop_name] => City
            [shop_district] => 2
        )

    [8] => Array
        (
            [shop_id] => 9
            [shop_name] => Lizard
            [shop_district] => 6
        )

    [9] => Array
        (
            [shop_id] => 10
            [shop_name] => Asda
            [shop_district] => 8
        )

    [10] => Array
        (
            [shop_id] => 11
            [shop_name] => Tesco
            [shop_district] => 2
        )

    [11] => Array
        (
            [shop_id] => 12
            [shop_name] => Tesco
            [shop_district] => 8
        )

)

Array
(
    [0] => Array
        (
            [shop_id] => 1
            [shop_name] => Aldi
            [shop_district] => 6
        )

    [1] => Array
        (
            [shop_id] => 2
            [shop_name] => Greggs
            [shop_district] => 6
        )

    [2] => Array
        (
            [shop_id] => 3
            [shop_name] => Tesco
            [shop_district] => 6
        )

    [3] => Array
        (
            [shop_id] => 4
            [shop_name] => Morrisons
            [shop_district] => 6
        )

    [4] => Array
        (
            [shop_id] => 5
            [shop_name] => Ryman
            [shop_district] => 6
        )

    [5] => Array
        (
            [shop_id] => 6
            [shop_name] => Boots
            [shop_district] => 6
        )

    [6] => Array
        (
            [shop_id] => 7
            [shop_name] => Superdrug
            [shop_district] => 6
        )

    [7] => Array
        (
            [shop_id] => 8
            [shop_name] => City
            [shop_district] => 2
        )

    [8] => Array
        (
            [shop_id] => 9
            [shop_name] => Lizard
            [shop_district] => 6
        )

    [9] => Array
        (
            [shop_id] => 10
            [shop_name] => Asda
            [shop_district] => 8
        )

    [10] => Array
        (
            [shop_id] => 11
            [shop_name] => Tesco
            [shop_district] => 2
        )

    [11] => Array
        (
            [shop_id] => 12
            [shop_name] => Tesco
            [shop_district] => 8
        )

)

Array 2:
Array
(
    [0] => Array
        (
            [SUM(item_price)] => 31.23
            [item_shop] => 1
        )

    [1] => Array
        (
            [SUM(item_price)] => 1.65
            [item_shop] => 2
        )

    [2] => Array
        (
            [SUM(item_price)] => 41.23
            [item_shop] => 3
        )

    [3] => Array
        (
            [SUM(item_price)] => 7.98
            [item_shop] => 4
        )

    [4] => Array
        (
            [SUM(item_price)] => 4.49
            [item_shop] => 7
        )

)


I'd love if anyone could tell me how I can generate an array that will combine bits of these two arrays, so that using the first array I can get a shop_name and shop_district for each item_shop (aka shop_id).  Then I want to get an array with entries that look something like this:
    [0] => Array
        (
            [SUM(item_price)] => 31.23
            [shop_name] => Aldi
            [shop_district] => 6
        )

Thanks so much for your help, it means a lot to me.

Hello!   First of all, I'm new here. I've been working with PHP for a few months and am really enjoying its capabilities   A little background on the project I'm doing at the mo, I'm creating a small dashboard for grabbing Twitter stats via the API. The result will eventually output in a pretty table showing the daily followers, follower gains (or losses) etc. Here's an example of the table I eventually want to end up with.   So far I have two arrays of data:   $accounts_data is a list of all account names and their associated ID's $followers_data is a list of all follower counts, for a specific time of day, with an associated account ID (which matches the ID found in $accounts_data, thus pairing the follower count to a specific account)   I'm now trying to combine these two arrays into something more sensible that can then be used to output the table as shown in the link above.   $accounts_data:

array(4) {
  [0]=> array(2) {
    ["id"]=> string(4) "1279"
    ["name"]=> string(13) "AccountName1"
  }
  [1]=> array(2) {
    ["id"]=> string(4) "1280"
    ["name"]=> string(10) "AccountName2"
  }
  [2]=> array(2) {
    ["id"]=> string(4) "1281"
    ["name"]=> string(12) "AccountName3"
  }
  [3]=> array(2) {
    ["id"]=> string(4) "1283"
    ["name"]=> string(11) "AccountName4"
  }
}

$followers_data (truncated this data)  

array(12) {
  [0]=>
  array(3) {
    ["account_id"]=> string(4) "1279"
    ["date_time"]=> string(19) "2014-11-14 09:00:03"
    ["followers"]=> string(4) "1567"
  }
  [1]=>
  array(3) {
    ["account_id"]=> string(4) "1280"
    ["date_time"]=> string(19) "2014-11-14 09:00:29"
    ["followers"]=> string(4) "7688"
  }
  [4]=>
  array(3) {
    ["account_id"]=>
    string(4) "1279"
    ["date_time"]=>
    string(19) "2014-11-14 16:30:35"
    ["followers"]=>
    string(4) "1566"
  }
}

I have a table called members.  Each member located within the members table has a unique id field called ID

I have a second table called user_program in which also contains the id number of the member from the members table

Each member has 5 entries in the table user_program using the field called program_id  which has a value of either 1, 2, 3, 4 or 5

Additionally there is a user_status field within the same user_program table

The value of user_status is either Active, Comped, Temp-Comped or Unpaid


What I am trying to do is determine is which is the highest program_id that a specific member holds a user_status equal to Active and then assign the program_id to a variable.


Here is the structure of the user_program table

user_program_id program_id user_status auto incrementing number     1 Active auto incrementing number     2 Active auto incrementing number     3 Unpaid auto incrementing number     4 Unpaid auto incrementing number     5 Unpaid

Here is the code I have been working with trying to figure it out.....any help would be appreciate :-)

Code: [Select]
$r1 = mysql_query("SELECT * FROM members WHERE Username='".$_SESSION['loggedin']."'");
$buffer_r1 = mysql_fetch_assoc($r1);
$usrid = $buffer_r1['ID'];


$r2 = mysql_query("SELECT * FROM user_program WHERE ID='".$usrid."'");
$buffer_r2 = mysql_fetch_assoc($r2);

$level_id = $buffer_r2['program_id'];
$user_status = $buffer_r2['user_status'];
$grace_start = $buffer_r2['grace_start'];



while(!$user_status ==("Comped" || "Unpaid")){
if($level_id == "1" && ($user_status == "Active")){
$level_name = "Professional";
}elseif($level_id == "2" && ($user_status == "Active")){
$level_name = "Gold";
}elseif($level_id == "3" && ($user_status == "Active")){
$level_name = "Diamond";
}elseif($level_id == "4" && ($user_status == "Active")){
$level_name = "Platinum";
}elseif($level_id == "5" && ($user_status == "Active")){
$level_name = "Elite";
}
}


I know the code within the while state is correct to assign the end variable, but my problem is that its only looking at the first program_id returned from the database that matches the user ID and does loop through the rest of the entries for that person.


Thanks in advance :-)

Hello, I've been struggling to get array_multisort to work...   If I have this array output... I'd like to sort on the product sub-array.   The array is called orders and that number 15 is the specific order id.

Array
(
    [15] => Array
        (
            [clientId] => 1
            [clientName] => Bob
            [o_date] => 2014-01-02
            [o_number] => 1 july-append
            [o_notes] => order on 1 july-append
            [i_date] => 2014-01-17
            [i_number] => 18072014-append
            [i_notes] => invoiced on 18 july 14 -append
            [products] => Array
                (
                    [0] => Array
                        (
                            [id] => 37
                            [prod_id] => 1
                            [product] => door
                            [qty] => 2
                            [cost] => 12.121
                        )

                    [1] => Array
                        (
                            [id] => 38
                            [prod_id] => 2
                            [product] => window
                            [qty] => 3
                            [cost] => 22.5
                        )

                    [2] => Array
                        (
                            [id] => 36
                            [prod_id] => 3
                            [product] => chair
                            [qty] => 1
                            [cost] => 300
                        )

                )

        )

)

So, I've tried a number of variations of this...

array_multisort($orders[$theOrder]['products'], SORT_DESC, SORT_NUMERIC, $orders[$theOrder]['products'], SORT_ASC, SORT_STRING);

array_multisort($orders[$theOrder]['products']['id'], SORT_DESC, SORT_NUMERIC);

etc. etc.
  - but I seem to get no-where. Can some-one kindly point out my error, please?   Thank you.

I am having trouble with a small PHP program.  I have to load item and   amount data from table cells into an array, and then be able to sort and   reverse sort the items in the cells.  I also have to track the errors   when non-numeric data is entered a s an amount, and total the numeric   amounts (These parts I think I have coded correctly.).
   
    I am having trouble with the array part.  I don't think item values are   being loaded into the array.  I debugged it as much as I could.  My code is here-- http://pastie.org/1084621 .
   
    I am completely new to this, having only done little PHP/JavaScript   programs like this for some classes in the last few months.  Any help would be greatly   appreciated.