C |
Cardei Mircea (@cardei) |
Hi to everyone,<br />
In the u.module.php it is a query that return a list of all your friends (friends of authentified user).<br />
My question is how I obtain the a list with all the members that are not friends of the authentified user.<br />
Maybe someone can post the query string for that.<br />
This can be very usefull and can help to develop a function that will randomly return members that are not your friends but they are from same location for example.<br />
<br />
The main purpose for this is to build a "People you may know" function.<br />
Thanks!
something like that:
[code]
sql_query("SELECT id
FROM ".tb()."accounts
WHERE (id NOT IN (SELECT fid
FROM ".tb()."friends
WHERE uid
= {$client['id']} ) AND id
<> {$client['id']}) ");
[/code]
Jcow Master @falcone
154 months ago
|