I have two ideas in my head that I would like to achieve using Data Tables but am unsure if it's possible....

Using:
Joomla 3
MySQL DB


1) display data newer than 1 day in bold

2) Click a line on data tables, which opens up a page or popup that pulls a table from the database which is equal to the name of the line...

So if the Line value was 8762346234, you could click it and a popup or joomla page would display and would show the database columns of 8762346234, but I want to create lots of joomla pages for each value, I want the page or popup to create itself based on the line value and pull the database table equal to the line value.

hope somebody can help
cheers

Or be able to change the SQL query depending on URL would be great, for example


URL


websiteaddress/index.php?product_id=[777656]

SELECT [URL-PRODUCT-ID] FROM databasetable;

Hello,

1. The extension doesn't support this ability.

2. It is possible to use request variables in WHERE clause of SQL query. For example if want to use product_id parameter from an URL, query will look like:

SELECT
*
FROM
tbl
WHERE
id = {$REQUEST:product_id}

It is possible to open a page with secondary table into a lightbox (for example in "ARI Sexy Lightbox" lightbox). You can read about primary and secondary tables here. About integration with "ARI Sexy Lightbox" is here.

Regards,
ARI Soft