Need help with birthday date within currentmonth

fifin04

Hi there...

Okay just a quick shoot....below are my currently table structure(MySql) to store the user birthday date

idbirthday | name | birthdaydate

0 | user 9 | 22-05-2007

1 | user8 | 01-05-2007

2 | user4 | 21-07-2007

3 | user2 | 05-05-2007

So how to setup a mysql_query so that I can only print the record which is within current month eg;current month "MAY"..so the correct output will be 3 record...so I really need help on it....any help are appreciated....thanks in advanced

bradgrafelman

I would highly suggest you alter your database so that the birthdaydate is a date column instead of VARCHAR (which I'm guessing it is now). That way, using the functions from the MySQL manual page for Date and Time Functions, it's pretty easy:

SELECT name FROM birthdays WHERE MONTH(birthdaydate) = MONTH(CURDATE())

NogDog

If birthdaydate is a date type column (which it should be, but from your example data does not appear to be):

SELECT * FROM `table` WHERE MONTH(CURDATE()) = MONTH(`birthdaydate`)

If birthdaydate is a character field of some sort:

SELECT * FROM `table` WHERE MONTH(CURDATE()) = MONTH(STR_TO_DATE(`birthdaydate`, '%d-%m-%Y'))

bradgrafelman

Note that altering your table structure so that birthdaydate is a DATE column is the more preferable method! :p

fifin04

Thanks for the help guys..it's works now....sorry for lateness reply.....

bradgrafelman

No problem... don't forget to mark this thread resolved.