所有即将到来的Facebook朋友的生日列表在Android [英] List of all Upcoming Facebook Friends Birthdays in Android

问题描述

如何让Facebook的生日按照即将到来的的顺序，如：show 列表中的最上面那些生日即将到来，使用当前日期等等。

仍然我以1月至12月的形式获得生日，1月份的生日快乐和12月份的生日底部。

而且我也是在1月2日或2月28日生日的1月份过去的那些生日的朋友，

现在我只想看看下一个即将到来的生日的列表，那些已经在列表底部的那些...

像这样： p>

https://itunes.apple.com/in/app/birthday-sweet-birthday-calendar/id367346406?mt=8

https://play.goog le.com/store/apps/details?id=com.scoompa.birthdayreminder&hl=en

他们已经在顶部和后面显示了在列表中...

仍然使用这个查询：

  String query =select name，birthday，uid，pic_square from user where uid in（select uid2 from friend where uid1 = me（））order by birthday_date; 
  

还试过这段代码：

 日历c = Calendar.getInstance（）; 
 int month = c.get（Calendar.MONTH）+1; 
 
 String query =select name，birthday，uid，pic_square from user where uid in+ 
（select uid2 from friend where uid1 = me（））AND birthday_date> =' + month +/ 01'AND birthday_date< ='+ month +/ 31'ORDER BY birthday_date ASC; 
  

解决方案

可以根据自己的生日对朋友列表进行排序。喜欢，

  SELECT uid，name，birthday_date FROM user 
 WHERE uid IN（SELECT uid2 FROM friend WHERE uid1 = me （））
 AND birthday_date> = CURRENT_DATE 
 AND birthday_date< = LAST_DATE 
 ORDER BY birthday_date ASC 
  

这里代替 CURRENT_DATE 可以输入当前的系统日期。所以这将显示从当前日期开始的即将到来的生日。并且代替 LAST_DATE ，您可以使用要显示即将到来的生日的日期。

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 form of January to December, Getting Friends on Top those birthdays in January and on bottom those birthdays in December.

and i am also getting friends on top those birthdays has gone in January like birthday was on 2nd Jan or 28 Jan,

Now i just want to see list of Next Upcoming Birthdays,those passed away on bottom of the list...

Like here:

https://itunes.apple.com/in/app/birthday-sweet-birthday-calendar/id367346406?mt=8

https://play.google.com/store/apps/details?id=com.scoompa.birthdayreminder&hl=en

they have shown recents on top and later on bottom in a List...

Still i am using this query :

    String query = "select name, birthday, uid, pic_square from user where uid in (select uid2 from friend where uid1=me()) order by birthday_date";

Also Tried with this code:

 Calendar c = Calendar.getInstance(); 
    int month = c.get(Calendar.MONTH)+1;

    String query = "select name, birthday, uid, pic_square from user where uid in " +
    "(select uid2 from friend where uid1=me())AND birthday_date >= '" + month + "/01' AND birthday_date <= '" + month + "/31' ORDER BY birthday_date ASC";

解决方案

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

SELECT uid, name, birthday_date FROM user
WHERE uid IN (SELECT uid2 FROM friend WHERE uid1=me())
AND birthday_date >= CURRENT_DATE
AND birthday_date <= LAST_DATE
ORDER BY 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.

这篇关于所有即将到来的Facebook朋友的生日列表在Android的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！