Build a Website

<?php $query = dbquery("SELECT SQL_NO_CACHE distinct user_two_id FROM messenger_friendships WHERE user_one_id = '" .USER_ID. "' GROUP by user_two_id"); $i = 0; while($friends = @mysql_fetch_array($query)) { $getfriend = dbquery("SELECT SQL_NO_CACHE distinct id,username,online FROM users WHERE id ='".$friends['user_two_id']."' AND online = '1' GROUP BY id LIMIT 1"); if(mysql_num_rows($getfriend) > 0) { $i++; if($i == 1) { echo ''; } $friend = @mysql_fetch_array($getfriend); $friendname = $friend['username']; echo htmlspecialchars($friend['username']).'</a>, '; } } if($i > 0) echo '</br>'; ?>