LalErrododigo
New Member
MySQL gives this error:\[code\]SQLSTATE[HY093]: Invalid parameter number\[/code\]for this query:\[code\]public function getUserFriends($userId) { $query = "SELECT users.id, users.firstName, users.lastName, users.thumbPic FROM friendships LEFT JOIN users ON ((friendships.user1 = users.id OR friendships.user2 = users.id) AND users.id <> :userId) WHERE (user1 = :userId OR user2 = :userId) AND friendships.status = 1"; return $this->adapter->prepare($query)->execute(array(':userId' => $userId))->fetchAll();}\[/code\]Parameter number looks ok to me or am I missing something?