List Of All Upcoming Facebook Friends Birthdays In Android

How to get Facebook Friends Birthdays in order of upcoming like: show top on list those birthdays are coming next by using current date and so on. still i am getting birthdays in f

Solution 1:

You can sort the list of friends according to their birthday. like,

SELECT uid, name, birthday_date FROMuserWHERE uid IN (SELECT uid2 FROM friend WHERE uid1=me())
AND birthday_date >=CURRENT_DATEAND birthday_date <= LAST_DATE
ORDERBY birthday_date ASC

Here in place of CURRENT_DATE you could enter the current system date. So this will show the upcoming birthday from the current date. and in place of LAST_DATE, you could use the date upto which you want to show the upcoming birthdays.