Hotlists Total in Profile View

Hello,

I am trying to modify my site to show the total hotlists a member has when viewing their profile.

I modified the BxBaseProfileView.php file as follows:

if($iBlockID == 20)
{
$hotlists = mysql_query("SELECT COUNT (*) FROM `HotList` WHERE `Profile`=".$this -> _iProfileID);



$sRet .= '

<tr>
<td class="profile_info_label">' . _t("_Hotlists") . ':' . '</td>
<td class="profile_info_value2">' . (int)$hotlists . '</td>
</tr>
';
}

The problem is that it shows that the member has "0" hotlists.  My test profile has 5 hotlists, but still displays 0 when viewing the profile.

What am I missing ???  I guess my code is wrong somewhere, but I don't know a whole lot abou this :)

Please, any suggestions ???

Thanks !!!

insert into its own file with proper requires and rework till it spits out proper value.

Got it working !!!  Thanks for the reply !!!