Hyperlinks in Tables

The sample table shows an example of how to build hyperlinks using the SQL CONCAT function. Here's the SQL used by the sample table. The %%J_ROOT_URI%% variable is used to provide the current site address.

SELECT `title` AS `Article`, DATE(`modified`) AS `Updated`,
    CONCAT('<a target="_blank" href="%%J_ROOT_URI%%/index.php?
    option=com_content&view=article&id=', `id`, '">', `title`, '</a>') AS `Link`
    FROM `#__content`
    ORDER BY `modified` DESC
    LIMIT 10