upcoming birthdays query

[onlyshanks28]

Hi

I have a database birthday containing name and DOB,
I want to find the query which can display 3 latest birth day.

I tried
select name,date from birthday where month(dob)>=mon th(curdate()) limit 3;

But the problem here is that on 31-December-2008 it will not display the birthdays on January.

Shashank

[r035198x]

Why are you taking the month parts?
Try something like [CODE=mysql]where dob >= curdate() order by dob limit 3;[/CODE]

[onlyshanks28]

Why are you taking the month parts?
Try something like [CODE=mysql]where dob >= curdate() order by dob limit 3;[/CODE]

Problem with it is:

If Current date is 31 december 08

then it will not display birthday in the moth if january 09

Also dob can never be more than currdate( )

MY dob is 28-08-1986(suppose) it cant be greater than currdate( )

[onlyshanks28]

for it we have to use three query subsequently

1) select name,date from days_to_remembe r where month(date)=mon th(curdate()) AND date(date)>=dat e(curdate()) order by date asc;

-----it will give upcomng bdays of same months---



2) select name,date from days_to_remembe r where month(date)>mon th(curdate()) order by date asc;

-----it will give upcomng bdays of next months---

3) select name,date from days_to_remembe r order by date asc;

-----it will give upcomng bdays of next year---


use a counter element to limit the number of elements

[r035198x]

Problem with it is:

If Current date is 31 december 08

then it will not display birthday in the moth if january 09

Also dob can never be more than currdate( )

MY dob is 28-08-1986(suppose) it cant be greater than currdate( )

Oh silly me. I get your point now. The year part should not be included in the comparison.

[onlyshanks28]

Oh silly me. I get your point now. The year part should not be included in the comparison.

thats correct
but
we do have to take into cosideration the year when the current date is
31-dec-2008..

the above 3 queries that i have given will do that perfectly

[RahulGuptaRG]

great
Thanks a lot.