Pagination problem with mysql in wordpress

I’m a novice with php and mysql so please be kind. The problem is I’m calling a database which as various states open, closed, pending etc, all this works fine.

The problem is when I click next on my pagination links the page just reloads to the start page with all states visible and the first 6 rows visible or if I’m on the start page its just the same page.

My code seems to work right as the url of next, prev page as a different start number for the start of the database query eg (http:………..wordpress/?page_id=1072?s=6&np=3).

I was wondering if this could be to with the URL i’m using for the links and wordpress.

please see code below, any help would be much appreciated.

[code moderated - please read http://codex.wordpress.org/Forum_Welcome#Posting_Code about using the pastebin]