Layer containing drilldown query

[Anon]

Is there a way to put a dynamically-generated SQL query into a layer which you display? I have a page which is simply a table returned by Query A. Each row in the table is a link, for example

row 1 | value
row 2 | value
row 3 | value
row 4 | value

Each of "row n" is a link. What I want to happen is that each link performs Query B with "row n" in the WHERE clause. So when you click on "row 2" you immediately perform a "SELECT ... from ... WHERE value='row 2'". Then, the results of Query B are placed into a layer and the layer is moved to the right location and displayed.

I'm already quite familiar with hiding and displaying layers and with doing DB queries. I'm just not sure of the best way to combine these two. The goal is to make the drilldown query appear next to the parent data, with the rest of the page intact. A related goal is that it must load as quickly as possible, since Query A is expensive and Query B is not.

[Anon]

There are 2 very different ways to do it:
1. You can do all the queries in advance and build the result in the page before it was loaded
2. Each click can call PHP, put data in layer and display it

Solution 1 sounds quite easy. You do you Query B for each row and put output in <div id="res_n" class=res></div>. In the head, use CSS to hide div.res by default. In each link created by Query A put onClick="showHideLayer('res_n'; return false". showHideLayer is the function that will change visibility of the layer. You need to build it differently for NS and IE.
I don't like this solution because the resulting page will be big and it may be bad for bandwidth. Also, can be hard on server if number of results of Query A is big.

Solution 2 is kinda hard from at point of JavaScript. You need to load external file (result of your click which would call Query B with parameter n) to layer. I do have this code somewhere, but don't know where. If this is what you need, let me know and I'll look for it.
This solution is kind of slow because user has to wait after each click. Still, this might be a good solution for Intranet where speed is no problem.

You might want to try hybrid solution, but this is much more complicated. First you list all the links, with onClick="clicked(n); return false;". Then list DIVs. JavaScript function clicked() than needs to check if the div called res_n (as show above) exists. If so, display it as in solution 1. If not, use solution 2.