Define ProductCustomField Variable on Template where not showing in Debug

[NetwiseHosting]

Hi All,

 

We are trying to display the output of the ProductCustomField variable on a template page in WHMCS, but the variable isn't currently showing when we run Debug.

 

I realise we need to create a connection to the database and pull the information from the table directly, but I am not overly sure how to do this - any advice would be greatly appreciated.

 

Am I right in saying we require a PHP include along the lines of this:

 

{php}<?php
$query = "SELECT * FROM `tblcustomfieldsvalues` WHERE 1"; 
$result = mysql_query($query);
while ($data = mysql_fetch_array($result))
{
$id = $data["fieldid"];
$value = $data["value"];
}

?>{/php}

 

The information we are trying to display is from a custom field called Additional IP Addresses if that helps.

 

Thanks in advance for your help,

 

Matthew