Group records by DATE

[brejualva]

For example, if several people birthday the same date that appears once the date and then the list of people..

[Darkick]

You are not first who asks about this function. I'll think about this in next versions.

[brejualva]

Thanks,

and I could help by changing the query please. IN HELPER.PHP

foreach ($rows as $row) {
$birthday = &JFactory::getDate($row['birthday']);
$age = (int)round(($today->toUnix() - $birthday->toUnix()) / (365 * 24 * 60 * 60));
$birthday_details = getdate($birthday->toUnix());
$new_birthday = &JFactory::getDate(mktime(0, 0, 0, $birthday_details['mon'], $birthday_details['mday'], $birthday_details['year'] + $age));
$days_left = (int)round(($new_birthday->toUnix() - $today->toUnix()) / (24 * 60 *60));
if (($days_left <= $days_before) && ($days_left >= -$days_after)) {

//CHANGE---------
$list[(200 + $days_left).'_'.$row['name']] = array('id' => $row['id'],'birthday' => $birthday, 'name' => $row['name'], 'new_birthday' => $new_birthday, 'age' => $age, 'days_left' => $days_left);