Friends (prepare("SELECT count(*) FROM friendships WHERE user1=:id AND isAccepted=1"); $q->bindParam(':id',$_SESSION['user'],PDO::PARAM_INT); $q->execute(); $numberOfFriends = $q->fetchColumn(); echo $numberOfFriends; ?>)
See all
= 1) {
foreach ($user->getFriends() as $friend) {
$frienduser = new User($con, $friend['friend']);
?>
";
} ?>
You have no friends.
";
} ?>
Recently Played
See all
prepare(str_replace('allStar', 'count(*)', $sql));
$q->execute();
$numberOfGames = $q->fetchColumn();
$q = $con->prepare(str_replace('allStar', '*', $sql));
$q->execute();
if ($numberOfGames >= 1) {
while ($game = $q->fetch()) {
$playingCount = $game['players'];
?>
";
} else {
echo "