birthday problem

phlow

i have a database with a "birthday" column (type: "date", "YYYY-MM-DD") and i need an mySQL query which compares todays date with the birthday date and if the months and days are equal, returns the name of the birthday boy (first_name).

thx, phlow

Anon

Use extract():

Select name
from bday_table
where extract(MONTH_DAY from b_day) = extract(MONTH_DAY from today);

phlow

that sounds good, but there's a little prob:
the script always causes a

"Warning: Supplied argument is not a valid MySQL result resource in birthday.php3 on line 11"

thats my query:
$result = mysql_query("SELECT * FROM members WHERE extract(MONTH_DAY from birthday) =
extract(MONTH_DAY from today)",$db);

i assume that "MONTH_DAY from birthday" writes "MM-DD" e.g. "09.12".

Anon

Sorry today isn't correct, it should be now() with the ().

See: http://www.mysql.com/doc/D/a/Date_and_time_functions.html

for all of the MySQL time/date functions.

phlow

sorry but i bother you all the time, but there is still the same error in the line after the query (but i think it means the query):

query: $result = mysql_query("SELECT * FROM members WHERE extract(MONTH_DAY from birthday) = extract(MONTH_DAY from now())",$db);

Anon

Sorry try this, and did you read that page I gave you the link to? The information is there for you to use don't expect other people to do your work for you.

select name from b_days
where MONTH(bday) = MONTH(now())
and DAYOFMONTH(bday) = DAYOFMONTH(now())

phlow

thanx, dude now it works!
by the way, i read the page you gave me, but i really couldn't find any relevant information.