Menaging records in a HTML table

frasco has asked for the wisdom of the Perl Monks concerning the following question:

Dear monks I have a problem with html tables and fetched records that probably depends on my poor skill on computer programming.
I have a MySQL db with 2 tables: the first stores a list of items (table A), the second stores features of the first table's items (table B). I wrote a small program to print an HTML page with a table with data from the table A.

1    item_1
2    item_2
3    item_3
4    and so on...

Now I woud like that on cliking on one of those items I could retrive pertinent data from table B. But I don't know actually how to generate such a process.
Can anyone tell me where I can find a tutorial for such a topic. Tanks.

Comment on Menaging records in a HTML table

Replies are listed 'Best First'.
Re: Managing records in a HTML table by sasdrtx (Friar) on May 12, 2008 at 10:33 UTC
You should probably try the Tutorials section first; look for the Web Programming section, particularly CGI Programming. The Q & A section also has lots of useful information. Fixed spelling in title -- I don't know what menaging might be, so this post could be off-topic. :-) sas	[reply]
Re: Menaging records in a HTML table by Anonymous Monk on May 12, 2008 at 08:56 UTC
CGI.pm	[reply]
Re: Menaging records in a HTML table by planetscape (Chancellor) on May 12, 2008 at 20:07 UTC
What you want is generally called "drilldown". Perhaps something like RFC : AJAX + DBI = DBIx::LiveGrid or HTML::Template, CGI, passing variables, launching new script would help get you started. HTH, planetscape	[reply]