avatar code error

i have trouble pulling from the post the avatar:

PHP Code:

$newssql=$DB_site->query("
SELECT * FROM thread
WHERE forumid='$newsforum'
ORDER BY dateline DESC LIMIT $newsposts
");
while ($news=$DB_site->fetch_array($newssql)) {
  $getnewssql=$DB_site->query_first("
  SELECT pagetext
  ".iif($avatarenabled,",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline","")."
  FROM post
  ".iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                         LEFT JOIN customavatar ON customavatar.userid=user.userid","")."
  WHERE threadid='$newsthreadid'
  ORDER BY postid ASC LIMIT 1
  ");
  $newstext=bbcodeparse($getnewssql[pagetext]);
  $newsavatar=$getnewssql[avatar];
} 


what do i do wrong?

[TECK]

lol.. i'm an idiot. i fix it in no time... sorry.

[Scott MacVicar]

it was the extra period before the equals

[TECK]

yes PPN.. i didnt see it.. i was sooo tired.