Despite countless searches on Google, I am still struggling to figure out how to sort a 3-dimensional associative array.
Specifically, my goal is to arrange each user's alert jobs based on the job's posted date.
Here is the code snippet:
$sql = "SELECT * FROM `bf_alert_stack` WHERE `type` = 'immediately' order by created desc";
$q = db_query($sql);
$user_alerts = array();
while ($row = db_fetch_array($q))
{
$user_alerts[$row['uid']][$row['alert_id']][$row['nid']] = $row['nid'];
}
In the $user_alerts array, $row['nid'] contains specific jobs for each user's alert.
When a user receives an email alert, the jobs should be displayed in sorted order based on the date.
The sample data from the $user_alerts array is shown below:
Array
(
[144320] => Array
(
[3568728] => Array
(
[30832] => 30832
)
[3568884] => Array
(
[30837] => 30837
[30827] => 30827
[30828] => 30828
[30830] => 30830
[30831] => 30831
[30832] => 30832
[30838] => 30838
[30839] => 30839
[30826] => 30826
[30806] => 30806
[30808] => 30808
[30807] => 30807
[30698] => 30698
[30697] => 30697
[30601] => 30601
)
)
[144330] => Array
(
[3568731] => Array
(
[30827] => 30827
[30839] => 30839
[30838] => 30838
[30837] => 30837
[30832] => 30832
[30831] => 30831
[30830] => 30830
[30828] => 30828
[30826] => 30826
[30806] => 30806
[30808] => 30808
[30807] => 30807
[30698] => 30698
[30697] => 30697
[30601] => 30601
)
)
[144218] => Array
(
[3568753] => Array
(
[30808] => 30808
)
)
[144216] => Array
(
[3568732] => Array
(
[30808] => 30808
)
)
)
I aim to sort the above user_alerts array based on row['nid'], but the details of row['nid'] are stored in a database table. All nid values should be rearranged according to the creation date of nid present in the table.