Help with incorrect code for showing message to only 1 "id" in "tblclientgroups"

[paperweight]

I'm trying to figure out the current smarty/WHMCS syntax to place a message on my clientareahome.tpl only to one specific clientgroup.

 

I have 2 clientgroups, so 1 is id=1 and 2 is id=2.

 

I am using this current code but it is incorrect and showing the message to all users. I only ant to show it to id=2 in the tblclientgroups. What should I change?

 

{php}
include("support/dbconnect.php");
include("support/includes/functions.php");
$query = "SELECT * FROM `tblclientgroups` WHERE id=2"; 
$result = mysql_query($query);
while ($data = mysql_fetch_array($result)) {
   $id = $data["id"];
   echo '<div><p><strong>WELCOME:</strong> We appreciate your support and always welcome your feedback!</p></div>';
}
{/php}

[WHMCS JamesX]

Remove that entire codeblock and replace it with this:

{if $clientsdetails.groupid eq "2"}<div><p><strong>WELCOME:</strong> We appreciate your support and always welcome your feedback!</p></div>{/if}

[paperweight]

Ah, so easy and I missed that in the {debug}!! Thank you so much!