login, другой nickname. И затем результат использую в другом запросе.
function UserN($id){
$sql ="SELECT u.nickname
FROM cms_users u
LEFT JOIN cms_comments c ON c.user_id = u.id
LEFT JOIN cms_ratings r ON r.item_id = c.id
WHERE u.id = $id";
$result = $this->inDB->query($sql);
if (!$this->inDB->num_rows($result)) { return false; }
$commen = $this->inDB->fetch_assoc($result);
return $commen;
}
function UserL($id){
$sql ="SELECT u.login
FROM cms_users u
LEFT JOIN cms_comments c ON c.user_id = u.id
LEFT JOIN cms_ratings r ON r.item_id = c.id
WHERE u.id = $id";
$result = $this->inDB->query($sql);
if (!$this->inDB->num_rows($result)) { return false; }
$commen = $this->inDB->fetch_assoc($result);
return $commen;
}
public function getRComment($id) {
$comments = array();
$sql = "SELECT c.*,
u.nickname as nickname,
u.login as login,
r.user_id as ruser,r.points as points
FROM cms_comments c
LEFT JOIN cms_ratings r ON r.item_id = c.id
LEFT JOIN cms_users u ON u.id = c.user_id
LEFT JOIN cms_user_profiles p ON p.user_id = u.id
WHERE c.id = r.item_id AND c.target_id=$id";
$result = $this->inDB->query($sql);
if (!$this->inDB->num_rows($result)) { return false; }
while($comment = $this->inDB->fetch_assoc($result)){
$comment['rnick'] = implode($this->UserN($comment['ruser']));
$comment['rlog'] = implode($this->UserL($comment['ruser']));
$comments[] = $comment;
}
return $comments;
}
Но с последней ф-ции приходит только
$comment['rnick'], а
$comment['rlog']
возвращает как 0. В чём может быть причина?