sql query for days until next birthday?

[eluser]Nick Husher[/eluser]

Code:

$this->db->select('short_name, MONTH(birthday) AS mon, DAYOFMONTH(birthday) AS mday');
$result = $this->db->get('birthday_list');

$row = $result->row_array();

$today = time();
$today_parts = getdate($today);

if($today_parts['mday'] <= $row['mday'] && $today)parts['mon'] <= $row['mon']) {
   $birthday_year = $today['year']; // birthday occurs on this calendar year/
} else {
   $birthday_year = $today['year']+1; // birthday occurs next calendar year.
}

$birthday = strtotime($birthday_year."-".$row['mon']."-".$row['mday']);

$days_difference = ($birthday - $today) / (60 * 60 * 24);

Something like that should work. I'm assuming that MONTH and DAYOFMONTH SQL functions return numbers, and you might have to do a little wiggling, but it basically does in PHP what the SQL does, and it's easier to follow.