http://qs1969.pair.com?node_id=1055166


in reply to Integration of SQL Search Results Into An Existing HTML Template

1) Put a tag in your template where you want the SQL results to appear. Something like <SQLDATA>

2) Run the SQL query

3) Convert the results into a basic HTML table, with some ID or class that you can use to style the table using CSS. This table should be put into a variable.

4) Load the template file into another variable

5) Replace the tag from step 1) with the contents of your table variable.

6) print "Content-Type: text/html\n\n";

7) Print out your converted template.