Help with birthday code

[darkfreaks]

how would i code something where it would check the birthdate in the database for the user and then check the current date and if there birthday falls on that month it would echo "happy bday $user"???

[bpops]

Without writing all the code out, here's the gist:

 

- input the birthdate for each user into the database as type 'date'

- grab this date from the database for a particular user

- get today's date with the date function ( date() ) formatted the same way as in mySql (YY-MM-DD)

- check for equality

[Northern Flame]

well in your database just insert there birthday,

choose a format, such as 02/13/2008

 

 

then do something like:

 

<?php

$query = mysql_query("SELECT * FROM users WHERE id='1'"); // Change this query, its just a sample!
$row = mysql_fetch_array($query);

$blow = explode('/', $row['birthday']);
$now = date("m/d/Y");
$break = explode('/', $now);

if($blow[0] == $break[0] && $blow[1] == $break[1]){
	$years = $break[2] - $blow[2];
	echo "Happy Birthday ". $row['user'] ."! You are $years old!";
}

?>

[darkfreaks]

what do we do if we have 3 int variables for date?

[Northern Flame]

just put them all in a variable

and then compare the month

with $break[0] and the day

with $break[1]