Login     Sign up
Category: Module Development
Cardei Mircea (@cardei)
148 months ago
1249 Views

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!

2 people followed this question
0

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
148 months ago