sortableTable nulls

[fireupjb]

Okay, trying to output in my addon a table that mimicks the base table HTML structure that WHMCS outputs; I see theres a sortableTable function , but every attempt I try fails... Any help?

 

use Illuminate\Database\Capsule\Manager as Capsule;

$query = "SELECT
whmcs.tbldomainpricing.extension AS TLD,
whmcs.tblpricing.msetupfee AS Selling_Price
FROM
whmcs.tbldomainpricing
INNER JOIN whmcs.tblpricing
 ON whmcs.tbldomainpricing.id = whmcs.tblpricing.relid
WHERE
whmcs.tblpricing.type = 'domainregister' 

ORDER BY
Selling_Price ASC";

$tabledata = "";
$result = full_query($query);

	while ($data = mysql_fetch_array($result, MYSQL_ASSOC)) {
		$TLD = $data['TLD'];
		$SELLING_PRICE = $data['Selling_Price'];
		$tabledata[] = array($TLD, $SELLING_PRICE);
	}
	echo $aInt->sortableTable(array('TLD', 'Selling_Price'), $tabledata);

 

I keep getting the infamous null error on sortabletable. Uncaught Error: Call to a member function sortableTable() on null

[fireupjb]

Okay, well i found out the null; I ended up using some code I found online, and $aInt wasnt declared. So that's a no go... Unless someone has a method they use?

[pRieStaKos]

Deprecated functionality

The current SQL Helper Functions are present in WHMCS 6.0 and above, but are now deprecated and may be removed in a later version of the product:

 

select_query()

update_query()

insert_query()

full_query()

 

Also mysql_fetch_array()

 

Check Interacting With The Database for Quering the database (you are using Capsule anyway)