How do I show a database query as a table?
Write a SELECT in a Database Table / Query data source to show data your site already holds, or use the External Database source to query another database on the same server or across the network. The result is current every time the page is displayed.
Step by step
The Database Table / Query Data Source
This article explains the Database Table/Query data source, which runs a SQL SELECT query against your own site's database in Joomla and WordPress to display results as a table. It covers writing queries using the #__ prefix placeholder, naming columns, ordering rows, limiting results, and avoiding line comments. It describes the Database Query field, Empty results message, Add header row checkbox, and Header row editor, plus placeholders like {user_id}, {user_name}, and {current_datetime} for personalised queries, and user parameters with types int, float, date, and cmd for safe query values.
Data Sources · Read the guide
The External Database / Query Data Source
The External Database/Query data source lets you display live data from a separate database on another server or machine. Configure the Database Driver, Database Host, Database User, Database Password, Database Name, and Database Query to connect and retrieve data. This article covers connection troubleshooting, the optional Database Prefix for table name shortcuts, security best practices for limiting account permissions, and configuration steps including the Add header row option and cache settings for remote databases on Joomla and WordPress.
Data Sources · Read the guide
How to Add a Header Row to a Database Table/Query Data Source
This article explains how to add header rows to database query tables in Tabulizer on Joomla and WordPress. It covers three methods: using the data source's Add header row option with the header row editor, adding a UNION statement in the SQL query, and creating an Add Row rule in step 5 of the Table Wizard. It also explains related settings like Source Type, 1 top header formatting, Insert Row Position, and Custom Row, plus troubleshooting issues like misaligned headings and 403 firewall errors.
Frequently Asked Questions (FAQ) · Read the guide
See it working
- Feature: Reading Local & Remote Data Sources
Have a different question?
The knowledge base covers every wizard, data source and option, and we are happy to answer anything it does not.
All solutions Contact us