|
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'm trying to get a list of user's friends using fb connect for the iphone.
I've tried both of the following FQL Queries, but they don't seem to be returning anything.
which one is correct if any ?
NSString* fql = [NSString stringWithFormat:@"select flid...
Started by dizy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
NSString* fql = [NSString stringWithFormat:@"SELECT name,uid FROM user WHERE.
Figured it out...
Uid IN ( SELECT uid2 FROM friend WHERE uid1=%lld )",[self fbSession].uid];
Can anyone tell me howAh..
|
|
What Facebook API call should I make in order to find new friends by First and Last name?
The functionality that I'm trying to achieve is similar to Find Friends page, but I have to do that programmatically.
Many thanks in advance.
Sincerely,
Roman
Started by Roman Kagan on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Where uid in (select uid2 from friend where uid1 = 123456);
this:
SELECT uid FROM user WHERE strpos("Chris", first_name) = 0 AND uid IN (SELECT uid2 FROM friend WHERE uid1 = 123456 )
where the uid1 value is ....
|
|
I'm usually a C# developer, but writing a mostly-client side application using jQuery.
It is reasonably straight forward: I have a list of "groups" which have some parameters (like a group name) and a list of "users" who also have some parameters.
At ...
Started by Michael Stum on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Group, i) { return group.name == "What I'm interested in"; });
It's the equivalent of a Select().Where", users: { uid1: { name: "User 1" }, uid2: { name: "User 2" }, uid3: { name: "User 3" } } }, group2: { name: "Group 2", users: { ....
|
|
Hello,
I am trying to write a Facebook query that will return all comments posted by a user to his friends,
however I can't seem to find the correct schema. Its as if there are no 'indexable' fields to build this.
Any suggestions please?
With thanks,
...
Started by Ws on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Unfortunately, this means like
select * from comments where....
Where sourceid in ( select uid1 from friend where uid2 = <my_id> ) )
for photos, substitute FQL Table , you can only select comments via a post ID or an xid.
|
