Help needed - fql query in facebook api

Question

I want to get my friends picture and their last status message with time.

message,time FROM status

pic_square FROM user

    $status = $facebook->api_client->fql_query("SELECT message,time FROM 
status WHERE uid in (SELECT uid2 FROM friend WHERE uid1=".$user.")");

    echo "<pre>";
    print_r($status);
    echo "</pre>";

above query returns all statuses, i just want only last status message. Also, how can i modify this query to get pic_square from user table.

Thanks in advance,

Answer 1

FQL accepts MySQL-style "ORDER BY" and "LIMIT" clauses. Order by time, and limit to one result.

Answer 2

status.get is much better for this purpose: http://wiki.developers.facebook.com/index.php/Status.get