You should make the same query as without the paging module, but add a " limit $limit offset $offset" to your SQL.

There are some examples of paging here in the monastery as well. Use Super Search to find them.

If you want some more specific help, you should post the code you've got so far, along with error messages and a description what it should do.