From your description I guess you need to update this table each time someone requests the page. I'd suggest using something like HTML::Template using a template loop and and the vaules from your SQL query. Rather than duplicate/repeate advice, see HTML::Template Tutorial for a well documented working exaple using CGI, DBI and HTML::Template.
|
|---|