Sorting data in array without changing the sort order

Question

I am grabbing data from the database, and sorting it in an array.

The data from the query (which is displayed in the proper order):

id    task_id    note    date_created    user_name    document_name    document_type
238   131        3g      1385563455      Admin        doc3             jpg
238   131        3g      1385563455      Admin        doc2             png
238   131        3g      1385563455      Admin        doc1             png
240   131        sd      1385563536      Admin        NULL             NULL
241   131        sd      1385563565      Admin        NULL             NULL
242   131        qw      1385563612      Admin        NULL             NULL

I then grab the data and store it in an array:

$all_notes = array();
foreach($notes as $note) {
    $all_notes[$note["id"]]["text"] = $note["note"];
    $all_notes[$note["id"]]["user_name"] = $note["user_name"];
    $all_notes[$note["id"]]["date"] = $note["date_created"];
    $all_notes[$note["id"]]["task_id"] = $_POST['task_id'];
    $all_notes[$note["id"]]["docs"]["document_name"][] = $note["document_name"];
    $all_notes[$note["id"]]["docs"]["document_type"][] = $note["document_type"];
}

When I echo the $all_notes array, the sort order is now completely opposite. Instead of the first row of data being id 238, it is now 242. Even when I change the query to sort the opposite way, the array is still sorting the data from 238 to 242 (and not 242 to 238, which is what it should be).

Your help will be greatly appreciated!

apoq · Accepted Answer · 2013-11-27 16:09:02Z

What you do in your code is assigning $id element of array with values from db, sure it'll get automatically filled up incrementally.

all_notes[239] = value1; all_notes[238] = value2; etc...

but if you print_r(all_notes), you get 238, 239,... etc, which is ok, as PHP arrays are filled up in incremental order by default;

try it like this:

$i=0;

$all_notes = array();

foreach($notes as $note) {

    $all_notes[$i]["id"] = $note["id"];
    $all_notes[$i]["text"] = $note["note"];
    $all_notes[$i]["user_name"] = $note["user_name"];
    $all_notes[$i]["date"] = $note["date_created"];
    $all_notes[$i]["task_id"] = $_POST['task_id'];
    $all_notes[$i]["docs"]["document_name"][] = $note["document_name"];
    $all_notes[$i]["docs"]["document_type"][] = $note["document_type"];

    $i++;
}

Now your array is filled up in the order it got from DB query.

Darius · Accepted Answer · 2013-11-27 15:37:40Z

1

Please see the array_flip() function. This will allow you to flip the order of the array.

http://us1.php.net/array_flip

The reason is, if you really think, the 242 values is going into the array first - its the first value coming off the $notes array.

Orrr... try adding ORDER BY DESC to the end of your SQL query. You did not specify how you previously attempted to change the sorting, btw.

Darius

answered Nov 27, 2013 at 15:37

Darius

6122 gold badges11 silver badges23 bronze badges

7 Comments

steeped Over a year ago

In the query, whether or not I add "ORDER BY notes.date_created DESC" or "ORDER BY notes.date_created ASC", the array will always output in the same reverse order.

Darius Over a year ago

Why not order by the ID if you truly want the results flipped... ? You can sort by more than one column you know - you can sort by ID first, then by date_created.

steeped Over a year ago

Same problem. This is my query: "SELECT notes.*, users.name as user_name, documents.name as document_name, documents.ext as document_type FROM users, notes LEFT JOIN documents ON notes.id = documents.note_id WHERE task_id=? AND notes.assigned_user_id = users.id ORDER BY id ASC"

steeped Over a year ago

The query returns the correct order, but once I place it into the array, the order gets reversed. No matter what I do to the query, the array is always returning that data flipped. I tried using the array_flip() function, but now my array won't display any data.

Darius Over a year ago

Did you do $notes = array_flip($notes); before the foreach() ?

|

Collectives™ on Stack Overflow

Sorting data in array without changing the sort order

2 Answers 2

Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related