Check your mail, please. We wrote that we installed
PHP Settings plugin. That bring pagination, sorting and search functionality, you can wrap 'ARI SQL Table' plugin with 'ARI JDataTable' plugin. Code will look like:
Code: |
{arijdatatable}
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="ID" alias="ID" width="50%" className="idg"}
{arisqltablecolumn id="NAME" alias="UserName" headerClassName="head"}
{/arisqltablecolumn}
{/arisqltablecolumns}
{arisqltablequery}
SELECT commune_link AS ID,province_name AS NAME
FROM communes
{/arisqltablequery}
{/arisqltable}
{/arijdatatable}
|
Regards,
ARI Soft