Show custom field value in the report.

[tiagocaus]

I am creating a new report.
I need to get the value of a custom field.

How do I get the value of the custom field to appear in the report?

 

$reportdata["tableheadings"] = array("Chave", "Client Name", "Telefone", "Product Name", "Service ID");


$result = select_query("tblhosting", "tblhosting.*, tblclients.firstname, tblclients.lastname, tblproducts.name, tblclients.phonenumber", array(
            "tblproducts.name"=>$tblproductsName,
            "tblclients.country"=>"BR",
            "domainstatus"=>$status, //Active, Pending, Terminated, Cancelled, Fraud
        ), "id","ASC","","tblclients ON tblclients.id=tblhosting.userid INNER JOIN tblproducts ON tblproducts.id=tblhosting.packageid"
);



while ($data = mysql_fetch_array($result)) {
    $serviceid = $data["id"];
    $userid = $data["userid"];
    $phonenumber = $data["phonenumber"];
    $clientname = $data["firstname"]." ".$data["lastname"];
    $productname = $data["name"];
    $phonenumber = str_replace(array(" ", "(", ")", "-"), "", $phonenumber);




    $reportdata["tablevalues"][] = array(
        "",   <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Chave
        $clientname,
        $phonenumber,
        $productname,
        '<a href="clientshosting.php?userid=' . $userid . '&id=' . $serviceid . '">' . $serviceid . '</a>'

    );
}