Your explanation is quite clear, but you do not seem to be totally clear in your understanding of what is happening on the client (browser) and what is happenning on the server.

Your cgi script runs on the server and so that cannot open new browser windows - the server cannot access the client machine except to respond to requests FROM the client.

Also, the server cannot POST or GET data to the client, it is the other way round. Again, the server sends data to the client as a response to a request.

What you will need to do to open a new browser window is to get the browser to do that - the best option here is JavaScript. That new window then requests the database results by requesting the cgi script from the server - this is also in JavaScript.

This will appear to operate in the way you describe, just what actually happens underneath is in a different order.

-- iakobski