[jeramie78]

Thanks for pointing out the typo ....i however did manage to get it working but only for VB avatars if someone has a custom one it will not work So if you can think of a way to get custom urls too i would greatly appreciate it.

PHP Code:

<?
    $avatarinfo = mysql_query("
        SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
            customavatar.width, customavatar.height
        FROM vb_user AS user
        LEFT JOIN vb_avatar AS avatar ON avatar.avatarid = user.avatarid
        LEFT JOIN vb_customavatar AS customavatar ON customavatar.userid = user.userid
        WHERE user.userid = $userid");

               $query_row=mysql_fetch_array($avatarinfo);

echo "<img src=\"forums/$query_row[avatarpath]\">";
?>