I'm new to this and haven't been able to make this work using the descriptions in the plugins.

I have a database that I want to query and then display that data using jdatatable.

Here is the code I have in the article.

{arijdatatable}
{arisqltable bPaginate="true"}
{ariconnectionstring dbHost="localhost" dbUser="***" dbPass="***" dbName="***" dbType="mysql"}

{arisqltablecolumns}
{arisqltablecolumn id="id" alias="id" className="idg"}
{arisqltablecolumn id="membernumber" alias="membernumber" headerClassName="head"}

{/arisqltablecolumn}
{/arisqltablecolumns}

{arisqltablequery}
SELECT id AS id, membernumber AS membernumber FROM jos_mgamembers
{/arisqltablequery}

{/arisqltable}
{/arijdatatable}

Can someone point me to an example of a jdatatable that queries a mysql database.

Any help is much appreciated.

Hello,

If you want to show data from Joomla! database using "ARI JDataTable" plugin, use the next code:



PS: Check that "System - ARI Smart Content" plugin is enabled and if you use a WYSIWYG editor, switch it to plain text mode before inserting plugin code.

Regards,
ARI Soft