phpBB.de

Code: Alles auswählen

$werte = array();
$res = mysql_query('
SELECT
	id,
	nachname,
	vorname,
	geburtstag,
	YEAR( CURRENT_DATE( ) ) - YEAR( geburtstag )
	age,
	DATEDIFF(geburtstag + INTERVAL
	(YEAR(CURRENT_DATE) - YEAR(geburtstag) +
	IF(DATE_FORMAT(CURRENT_DATE, "%m%d") >
	DATE_FORMAT(geburtstag, "%m%d"), 1, 0))
	YEAR, CURRENT_DATE) AS days_to_birthday
FROM
	personen
HAVING
	days_to_birthday <= 6 OR
	days_to_birthday >= 360
ORDER BY
	days_to_birthday');

while($row = mysql_fetch_row($res))
{
$werte[] = $row;
}

Code: Alles auswählen

		$start_day = date('m-d', time() - 604800); // vor 7 Tagen
		$end_day = date('m-d', time() + 1209600); // in 14 Tagen
		$sql = 'SELECT user_id, username, user_birthday
			FROM ' . USERS_TABLE . "
			WHERE DATE_FORMAT(user_birthday, '%m-%d') BETWEEN '$start_day' AND '$end_day'";

Code: Alles auswählen

function user_age($user_birthday)
{
	$user_birthday = explode('-', $user_birthday);
	
	$age = date('Y') - $user_birthday[0];
	if (date('m') < $user_birthday[1] || (date('m') == $user_birthday[1] && date('d') < $user_birthday[2]))
	{
		$age--;
	}
	
	return $age;
}

Code: Alles auswählen

		$now = explode('-', date('Y-m-d'));
		while ($row = $db->sql_fetchrow($result))
		{
			$user_birthday = explode('-', $row['user_birthday']);
			if ($user_birthday[1] == $now[1] && $user_birthday[2] == $now[2])
			{
				// hat heute Geburtstag
				
				$display_age = user_age($row['user_birthday']);
			}
			else if ($user_birthday[1] <= $now[1] && $user_birthday[2] <= $now[2])
			{
				// hatte in der Vergangenheit Geburtstag
				
				$display_age = user_age($row['user_birthday']);
			}
			else if ($user_birthday[1] >= $now[1] && $user_birthday[2] >= $now[2])
			{
				// hat in der Zukunft Geburtstag
				
				$display_age = user_age($row['user_birthday']) + 1;
			}
			
			$template->assign_block_vars('birthdays', array(
				'USERNAME' => $row['username'],
				'AGE' => $display_age,
				
				'U_PROFILE' => common_url('profile', $row['user_id']))
			);
		}
		$db->sql_freeresult($result);

Code: Alles auswählen

Fatal error: Call to a member function on a non-object

Code: Alles auswählen

while ($row = $db->sql_fetchrow($result))