Hello, I am using a SQL table wrapped in a JDataTable, what I would like to do is to show a list of both articles and kunena posts in a list, with the title linked to the article. At the moment my code in the module is:
| Code: |
{arijdatatable bPaginate="true"}
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="DATE" alias="Date" width="15%" className="idg"}
{arisqltablecolumn id="CAT" alias="Category" width="15%" headerClassName="head"}
{arisqltablecolumn id="TITLE" alias="Title" headerClassName="head"}
{/arisqltablecolumns}
{arisqltablequery}
SELECT FROM_UNIXTIME(time) AS DATE, 'POST' AS CAT, subject AS TITLE
FROM #__fb_messages
UNION
SELECT created AS DATE, 'ARTICLE' AS CAT, title AS TITLE
FROM #__content
{/arisqltablequery}
{/arisqltable}
{/arijdatatable}
|
I have tried to use sql CONCAT to add an <a> tag to make the link, but it seems that html tags get stripped off the list. Is there a way I can make the title column entries linkable?
Thank you
