fql.multiquery返回空数组

问题描述：

我正在查询页面的所有相册并获取每张专辑的封面照片。下面是我有的代码返回一个空的结果。fql.multiquery返回空数组

我能够两个查询分开没有问题，所以它不是一个权限问题。

$album_fql = "SELECT aid, owner, name, object_id, cover_pid, cover_object_id 
       FROM album 
       WHERE owner = 'xxxxxxx'"; 

$albumpic_fql = "SELECT pid, src_small 
       FROM photo 
       WHERE pid IN (SELECT cover_pid FROM #query1)"; 

$album_param = array(
       'method' => 'fql.multiquery', 
       'queries' => '{"query1":"' . $album_fql . '", "query2":"' . $albumpic_fql . '"}'); 

$album_fqlResult = $facebook->api($album_param); 

print_r($album_fqlResult);

任何想法？

是否超时？该页面是否有大量相册？ – 2011-12-29 22:09:29

答

你可以在嵌套查询而不是多查询中做到这一点。

SELECT pid, src_small 
FROM photo 
WHERE pid in (SELECT cover_pid FROM album where owner={page id here})

例如这里的专辑列表中涵盖了我从可口可乐的Facebook页面

SELECT pid, src_small 
FROM photo 
WHERE pid in (SELECT cover_pid FROM album where owner=40796308305) 
LIMIT 5

返回了：

{ 
    "data": [ 
    { 
     "pid": "40796308305_2143765", 
     "object_id": 110516463305, 
     "src_small": "https://fbcdn-photos-a.akamaihd.net/hphotos-ak-snc1/6570_110516463305_40796308305_2143765_6253354_t.jpg" 
    }, 
    { 
     "pid": "40796308305_8753877", 
     "object_id": "10150500888203306", 
     "src_small": "https://fbcdn-photos-a.akamaihd.net/hphotos-ak-ash4/398389_10150500888203306_40796308305_8753877_1814220329_t.jpg" 
    }, 
    { 
     "pid": "40796308305_8751674", 
     "object_id": "10150500434253306", 
     "src_small": "https://fbcdn-photos-a.akamaihd.net/hphotos-ak-ash4/407475_10150500434253306_40796308305_8751674_1040781388_t.jpg" 
    }, 
    { 
     "pid": "40796308305_8742570", 
     "object_id": "10150498588158306", 
     "src_small": "https://fbcdn-photos-a.akamaihd.net/hphotos-ak-ash4/396541_10150498588158306_40796308305_8742570_1378170213_t.jpg" 
    }, 
    { 
     "pid": "40796308305_8742259", 
     "object_id": "10150498546173306", 
     "src_small": "https://fbcdn-photos-a.akamaihd.net/hphotos-ak-snc7/402667_10150498546173306_40796308305_8742259_287537096_t.jpg" 
    } 
    ] 
}

如果你想试试你multiquery，然后尝试命名从索引0开始而不是1开始查询query0和query1这是C＃SDK允许的唯一方式，也许php SDK也是如此。

感谢您的回应！我还需要得到专辑的名称，从我读过的内容来看，这需要我认为的多重查询。 – teamdane 2011-12-30 16:07:00

答

终于明白了。我不得不将这些查询合并到1个变量中并且转义单引号。

$queries = '{ 

"query1" : "SELECT aid, name, cover_pid FROM album WHERE owner = \'xxxxxxxxxxx\'", 

"query2" : "SELECT aid, images FROM photo WHERE pid IN (SELECT cover_pid FROM #query1)" 

}';

fql.multiquery返回空数组

相关推荐