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 Code:
{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