From 15f2ce5459153336dfb53abcdbb557bf9f2e51c0 Mon Sep 17 00:00:00 2001 From: Friendika Date: Wed, 9 Nov 2011 19:30:14 -0800 Subject: contact edit updates --- include/socgraph.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'include/socgraph.php') diff --git a/include/socgraph.php b/include/socgraph.php index 7f3ad7322..87a7543de 100644 --- a/include/socgraph.php +++ b/include/socgraph.php @@ -150,7 +150,8 @@ function common_friends($uid,$cid) { $r = q("SELECT `gcontact`.* FROM `glink` left join `gcontact` on `glink`.`gcid` = `gcontact`.`id` where `glink`.`cid` = %d and `glink`.`uid` = %d - and `gcontact`.`nurl` in (select nurl from contact where uid = %d and self = 0 and id != %d ) ", + and `gcontact`.`nurl` in (select nurl from contact where uid = %d and self = 0 and id != %d ) + order by `gcontact`.`name` asc ", intval($cid), intval($uid), intval($uid), @@ -181,7 +182,8 @@ function all_friends($uid,$cid,$start = 0, $limit = 80) { $r = q("SELECT `gcontact`.* FROM `glink` left join `gcontact` on `glink`.`gcid` = `gcontact`.`id` - where `glink`.`cid` = %d and `glink`.`uid` = %d LIMIT %d, %d ", + where `glink`.`cid` = %d and `glink`.`uid` = %d + order by `gcontact`.`name` asc LIMIT %d, %d ", intval($cid), intval($uid), intval($start), -- cgit v1.2.3