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:
$query = "SELECT * FROM `tblcustomfieldsvalues` WHERE 1";
$result = mysql_query($query);
while ($data = mysql_fetch_array($result))
$id = $data["fieldid"];
$value = $data["value"];
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,