SQL Help: Can't show $dedicatedip on Invoice

[DemoTiger]

Hello,

 

I am trying to show a dedicated IP of VPS on Invoice but it does not work.

 

 

 

Here is my code:

 

{php}
   $whmcs_path = '/user/path/whmcs/';
   require($whmcs_path . 'configuration.php');
   $db = new mysqli($db_host, $db_username, $db_password, $db_name);
   $details = $this->get_template_vars('clientsdetails');
$query = mysql_query("SELECT dedicatedip FROM `tblhosting` WHERE `id` = '$serviceid'");
   $result = mysql_fetch_array($query);
   $ipAddress = $result['dedicatedip'];
   echo $ipAddress;
{/php}