Hi,

I just installed all of the package Data Tables and configured a module with an external database.
In this datbase is a tabel called "Players" from which I want to show the data in frontend by the module.
This Tabel is build in a sub dtabase at the normal Joomla databse and filled with a frontend parser. everthing works fine but what "calls" the data out from this database ?

This one ?
SELECT *
FROM `Players`
LIMIT 0 , 30

The connection to the external database should be oke.
Tabletype= Ari Data Table
Sourcetype= SQL

Can you provide me with some help ?

Thanx in advance

Regards
Frank

Hello,

The module shows data from a database based on SELECT SQL query. The query is entered in "SQL -> SQL query" parameter. In your case the query is:

SELECT *
FROM `Players`
LIMIT 0 , 30

Regards,
ARI Soft

I'm sorry but you reply with

SELECT *
FROM `Players`
LIMIT 0 , 30

but it is the same as I said. So how can I call the databse-data in a right way ?
I get now this error:

Warning: array_flip() expects parameter 1 to be array, null given in /home/huminator/domains/huminator.nl/public_html/modules/mod_aridatatables/mod_aridatatables.php on line 81
No data available.

Though, there is data in the table 'Players' into my database.

Set "SQL -> Debug" parameter to "Yes" and set "SQL -> Revert data" and "SQL -> Graph transformation -> Enable" parameters to "No".

Regards,
ARI Soft

extra info....config module-part External DB.

OKay I'm one step further.

Now I get this error: (syntax SQL ?)

(mysql): SELECT * FROM `Players` LIMIT 0 , 30 LIMIT 0,1
Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,1' at line 3

Warning: array_flip() expects parameter 1 to be array, null given in /home/huminator/domains/huminator.nl/public_html/modules/mod_aridatatables/mod_aridatatables.php on line 81
No data available.