my script would produce 2 long and complex table. the problem, is my user want the 2nd table to print on seperate page. how can I do this?
2 queries on 2 pages, or 1 query on 1 page with the info saved in a session for the second page.
if it's actual PRINTING you want to control, check the PAGE controls available in cascading style sheets. You can use these to control the forcing of a new page when printing.