Facebook PHP SDK生日APP使用FQL和HTML(Facebook PHP SDK Birthday APP using FQL and HTML)

 我使用FQL查询来获取用户朋友的生日。 但我想根据月份和日期对用户进行排序，这样一个月内的所有生日必须在div中，其id是月份名称中的前3个字母，因为我使用JS来显示/隐藏月份。 这可以实现吗？ 
 
 代码到目前为止.. 
 
$query = "SELECT uid, first_name, last_name, birthday_date, sex, pic_square, current_location, hometown_location FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me()) AND strlen(birthday_date) != 0 ORDER BY birthday_date";

$prm  =   array(
      'method'    => 'fql.query',       
      'query'     => $query,
      'callback'  => ''     
      );

$friends  =  $facebook->api($prm);

$sort = array();
foreach($friends as $friend){
// note the extra 0's here, to give us padding to filter out duplicate  array keys
// this gives us an int in the format 030100, 093100, etc
  $key = (int)date('Md00', strtotime($friend['birthday_date']));

// make sure we don't have duplicates...if the key already exists, incrememnt it by one
  while(isset($sort[$key])) $key++;
  $sort[$key] = $friend;
}
// sort the items by array key
ksort($sort);
 
 感谢安德鲁和大卫帮助我这一点:) 

I use a FQL query to get birthdays of user's friends. But I want to sort the users according to month and day, such that all birthdays in a given month must be in a div whose id is the 1st 3 letters in the name of the month as I use JS to show/hide months. Is this achievable?
 
Code so far..
 
$query = "SELECT uid, first_name, last_name, birthday_date, sex, pic_square, current_location, hometown_location FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me()) AND strlen(birthday_date) != 0 ORDER BY birthday_date";

$prm  =   array(
      'method'    => 'fql.query',       
      'query'     => $query,
      'callback'  => ''     
      );

$friends  =  $facebook->api($prm);

$sort = array();
foreach($friends as $friend){
// note the extra 0's here, to give us padding to filter out duplicate  array keys
// this gives us an int in the format 030100, 093100, etc
  $key = (int)date('Md00', strtotime($friend['birthday_date']));

// make sure we don't have duplicates...if the key already exists, incrememnt it by one
  while(isset($sort[$key])) $key++;
  $sort[$key] = $friend;
}
// sort the items by array key
ksort($sort);
 
Thanks to andrew and david for helping me this far:)

原文：https://stackoverflow.com/questions/5610749