|
I need to write queries to find out new users and regular users .
new users are the ones whose uuid appeared in last 24 hours (from now minus the time query is fired) in table2 and was not there before.
regular users are the ones whose uuid appeared in...
Started by Amit on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For example:
select, IsNewUser
I'm not all that familiar with MySQL, but here's how I'd do it in Oracle:
SELECT uuid, 'NEW' as user_type FROM (SELECT....
When there's no day-old match, fields in the left joined table will be NULL .
|
|
Hi! If i have uid of user is there any way to fetch the user list of this user? i tried "SELECT uid2 FROM friend WHERE uid1=UID" but this return permission error.
My purpose is to find out if me and given user has mutual friends of second, third etc. ...
Started by yav on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The only way is to get them to give you offline_access and then you can use them... .
Nope, you can't get users who are not authorized, this will be againts facebook's policy .
You can only retrieve friend lists of users who have authorized your application .
|
|
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=...
Started by anthony on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Status.get is much better for this purpose: http://wiki.developers.facebook.com/index.php/Status.get.
Order by time, and limit to one result.
FQL accepts MySQL-style "ORDER BY" and "LIMIT" clauses.
|
Ask your Facebook Friends
|
Situation:
my facebook application ( http://apps.facebook.com/mymagicmirror/ ) needed to detect user's gender, and then query opposite sex or male or female
FQL:
SELECT uid, name, pic, sex FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1='.$...
Started by Unreality on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You may also find http://forum.developers.facebook.com/viewtopic.php?pid=1....
From http://forum.developers.facebook.com/viewtopic.php?pid=174065 :
Just pass english locale (en_US) to the API call and it should return you genders in english (male/female) .
|
|
I have a table (participants) which has multiple columns that could all be distinct. Two columns that are of special interest in this query are the userID and the programID I have a two part inquery here.
I want to be able to acquire the list of all userIDs...
Started by mattgcon on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Here's your query for part 2:
SELECT DISTINCT p1.programID, COUNT.
select userID , SUM(userID ) AS Count from Preparations group by userID where Count > 1
Your query for part one looks good.
|
|
I'm wondering if this is the best way to tackle this issue. I am merging a Facebook users friends data, (from facebook - returns a multi array) with the votes from the users in that list that voted (from MySQL).
This is how I accomplished this. I'm a ...
Started by Brandon G on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Last_name FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1=$this->user" );
could IN (SELECT uid2 FROM friend WHERE uid1=$this->user)" );
because the uid is the only thing you_name, last_name FROM user WHERE....
|
|
I am developing a facebook application and i have this code here which queries the user id and other information:
Code: $users = $facebook->api(array('method' => 'fql.query', 'query' => "SELECT uid, last_name, pic_big FROM user WHERE uid IN( ...
Started by Albana_12 on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at webdeveloper):
|
|
Hi everyone,
i am developing a facebook application and here i am, struggling with this piece of code. I have this php query result here:
$id = $facebook->api(array('method' => 'fql.query',
'query' => "SELECT uid FROM user WHERE uid IN(
SELECT...
Started by Albana_12 on
, 5 posts
by 2 people.
Answer Snippets (Read the full thread at codingforums):
But if you wanna do it that way:
Set up the array:
Code: var user_ids = [];
and then each time you want to store a new user id:
Code: user_ids.push( <?php echo json_encode... .
I am not sure if they best way to store the user id's, are through javascript .
|
|
I am developing a facebook application and i have this code here which queries the user id and other information:
Code: $users = $facebook->api(array('method' => 'fql.query', 'query' => "SELECT uid, last_name, pic_big FROM user WHERE uid IN( ...
Started by Albana_12 on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at codingforums):
|
|
I am developing a facebook application and i have this code here which queries the user id and other information:
Code:
$users = $facebook->api(array('method' => 'fql.query',
'query' => "SELECT uid, last_name, pic_big FROM user WHERE uid IN(
...
Started by احمد حسن on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at nahdacenter):
|
