Hi all,
I'm currently having difficultly sorting the following multi dim array.
This is what i have:
$query_today_messages = mysql_query("SELECT *,date_format(pm_messages.pm_message_date, '%e %b') AS date FROM pm_messages INNER JOIN pm_projects ON pm_messages.pm_project_id=pm_projects.pm_project_id INNER JOIN pm_categories ON pm_messages.pm_categories_id=pm_categories.pm_categories_id WHERE pm_messages.pm_project_id = '" . $_SESSION['project_info']['2'] . "' AND TO_DAYS(pm_messages.pm_message_date) = TO_DAYS(NOW())");
while ($row = mysql_fetch_array($query_today_messages)) {
$today[] = array($row['pm_message_date'],$row['pm_message_title'],$row['pm_message_id'],'m',$row['pm_user_id'],$row['pm_user_type'],$row['date'],$row['pm_project_name'],$row['pm_categories_name']);
}
$query_today_comments = mysql_query("SELECT *,date_format(pm_comments.pm_comment_date, '%e %b') AS date FROM pm_messages,pm_comments,pm_projects WHERE pm_messages.pm_message_id=pm_comments.pm_message_id AND pm_messages.pm_project_id=pm_projects.pm_project_id AND pm_messages.pm_project_id = '" . $_SESSION['project_info']['2'] . "' AND TO_DAYS(pm_comments.pm_comment_date) = TO_DAYS(NOW())");
while ($row = mysql_fetch_array($query_today_comments)) {
$today[] = array($row['pm_comment_date'],$row['pm_comment_text'],$row['pm_message_id'],'c',$row['pm_user_id'],$row['pm_user_type'],$row['date'],$row['pm_message_title']);
}
$query_today_milestones = mysql_query("SELECT *,date_format(pm_milestones.pm_milestone_subdate, '%e %b') AS date FROM pm_milestones,pm_projects WHERE pm_milestones.pm_project_id=pm_projects.pm_project_id AND pm_milestones.pm_project_id = '" . $_SESSION['project_info']['2'] . "' AND TO_DAYS(pm_milestones.pm_milestone_subdate) = TO_DAYS(NOW())");
while ($row = mysql_fetch_array($query_today_milestones)) {
$today[] = array($row['pm_milestone_subdate'],$row['pm_milestone_title'],$row['pm_milestone_id'],'s',$pm_client_id,$row['date'],$row['pm_project_name']);
}
$query_today_todos = mysql_query("SELECT *,date_format(pm_todo_list.pm_todo_list_date, '%e %b') AS date FROM pm_todo_list,pm_todo,pm_projects WHERE pm_todo_list.pm_todo_id=pm_todo.pm_todo_id AND pm_todo.pm_project_id=pm_projects.pm_project_id AND pm_todo.pm_project_id = '" . $_SESSION['project_info']['2'] . "' AND TO_DAYS(pm_todo_list.pm_todo_list_date) = TO_DAYS(NOW())");
while ($row = mysql_fetch_array($query_today_todos)) {
$today[] = array($row['pm_todo_list_date'],$row['pm_todo_list_item'],$row['pm_todo_id'],'t',$row['pm_user_id'],$row['date'],$row['pm_project_name']);
}
foreach ($today as $t) {
echo $t['0'] . " " . $t['1'] . "<BR>";
}
and the output i get is:
20041111032722 Update
20041111213206 Testing Messages
20041111142622 Looking good
20041111161531 List Item 2
20041111161112 List Item 1
20041111171533 List Item 3
20041111202241 Create red admin links
The $t['0'] column is timestamp(14)
I was wanting the out put to look like:
(ie. Most recent date first)
20041111213206 Testing Messages
20041111202241 Create red admin links
20041111171533 List Item 3
20041111161531 List Item 2
20041111161112 List Item 1
20041111142622 Looking good
20041111032722 Update
Any ideas how to achieve this? I have used rsort() but the results aren't correct.
Cheers,
micmac
