所有即将到来的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屋!