I am using a Custom File and to get display the record i use the following code.
echo $db->ExecuteHtml($sql1, array("fieldcaption" => TRUE, "tablename" => array("products", "categories")));
It show the query results as table. and I would like to make some changes in the results as follows.
1) How can I make the table header look like the project table header.
2) In one column I would like to make HYPERLINK
eg. In the display table I have a column name "id"
and i would like to make this column a hyperlink.