How to correct code to display message only to domainstatus=Active in tblhosting?

[paperweight]

I want to display a short message to only users who have a Paid product in the domainstatus=Active in the tbhosting. I put together the code below but it seems to be wrong somewhere and I can not figure what I did incorrect:

 

 

{php}
// BEGIN TO CHECK IF USER HAS PAID PRODUCT OR NOT
// take the user's id
$userID = $_SESSION["uid"];
// try to find that user among tblhosting to see if they in fact have an Active product	
$sql = "SELECT id FROM tblhosting WHERE domainstatus='Active' AND userid = ".$userID;
$result = mysql_query($sql);
$rows = mysql_num_rows($result);
// if found
if ($rows > 0)
{
	$this->assign('isPAIDClient',"Y");
}
// if not
else
{
	$this->assign('isPAIDClient',"N");
}
// END TO CHECK IF USER HAS PAID PRODUCT OR NOT
{/php}
{if $isPAIDClient eq "Y"}show this...{/if}
{if $isPAIDClient eq "N"}show this other content...{/if}

 

I think I made a mistake on the $rows but I'm unclear if I should show >1 or something else?

[paperweight]

Ok, I solved this in a very very easy way

 

I used this simple code to display it:

 

{if $clientsstats.productsnumactive>0}{/if}

 

So no need to use any MySQL calls!