I think you’d need to run the query again and instead of displaying the results, use the various fpdf functions to place the data in your PDF file. Or maybe if it won’t place too much of a strain on the server, generate the PDF at the same time as you generate the html, so the link is just to download it rather than to generate it on the fly.
Aren’t there any examples on the fpdf site that you can work through?