How to access database separately having more then one pagination code?

How to access database separately having more then one pagination code?

I'm accessing database having pagination code with a simple query. It
works fine, all the (available) pages appear serially.

Then I accessed the same database (from a different php file) having
pagination code with a different query. It also works fine to identify how
many pages there are according to query.

now, as you can see I got 2 pages from the second query. Here the problem
starts, when I click on the page 2

it takes me to the page 2 of the 1st query I ran. And gives me totally
wrong output (not the required records from database)

why is this happening? at first I had same pagination code for both of the
query (paging.php) but now I have separate code (paging1.php and
paging2.php ) for the two queries. still I'm having the same problem. can
anyone tell where did I go wrong?
Edited:
the codes are in here: Why am I having pagination link go to the previous
accessed data page?