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,
FQL accepts MySQL-style "ORDER BY" and "LIMIT" clauses. Order by time, and limit to one result.
As ceejayoz says, your query would need to be:
$status = $facebook->api_client->fql_query("SELECT message,time FROM
status WHERE uid in (SELECT uid2 FROM friend WHERE uid1=".$user.") ORDER BY time LIMIT 1");
echo "<pre>";
print_r($status);
echo "</pre>";
status.get is much better for this purpose
I am trying to write a script to prevent brute-force login attempts in a website I m building. The logic goes something like this: User sends login information. Check if username and password is ...
<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...
I found this script online that creates a thumbnail out of a image but the thumbnail image is created with poor quality how can I improve the quality of the image. And is there a better way to create ...
如何确认来自正确来源的数字。
Most sites need some way to show the dates on the site in the users preferred timezone. Below are two lists that I found and then one method using the built in PHP DateTime class in PHP 5. I need ...
I wonder there is a way to post a message to a facebook business page with cURL? thanks
I want to create text as a watermark for an image. the water mark should have the following properties front: Impact color: white opacity: 31% Font style: regular, bold Bevel and Emboss size: 30 ...
How does php cast boolean variables? I was trying to save a boolean value to an array: $result["Users"]["is_login"] = true; but when I use debug the is_login value is blank. and when I do ...