Thank you but that doesn't solve my problem.

It wasn't meant to solve your problem (it wasn't an answer) -- its a way to organize your code so that solving the problem is easier than easy ... its about a million times easier to debug HtmlPrinter() or PaginationLinks() than HtmlPrinterAndDatabaseQueryAndCGIQueryAndPaginationLogicAllWhileEscapingQuotes()

You want to debug the smallest piece possible, not the whole thing at once in a blender ; Its how you can solve your own problem and makes it a joy for others to help you

I removed the subs that I had to simplify the script until I can figure out how to get paging working.

You will never figure it out that way ... and its very painful for folks trying to help you ...

Its kind of like building a bed out of wood by only using a drill -- how are you cutting your lumber, using saw? No, I'm drilling it ... very slow going and painful ...

Perl gives subs, gives you double quoted strings where you don't have to escape quotes ... it gives you all manner of tools besides drill