Pagination [doing my head in]...anyone...please?

[eluser]Wonder Woman[/eluser]
If you see the comment, it says there is more queries, of course I'm not pulling back an incomplete sql search.

Its just too long to post it all on here.

I realise the error is to do with the offset and total of rows from the query.