NEED suggestions on search results output

[zzz]

I run a query on a table and the number of the output lines may vary based on the match of the specified parameter.

Since sometimes it may have quite a few lines of output I need some sort of paging solution.

I use one on regular pages, where I can get TOTAL lines prior the output. In the search, however I do not know the number of rows that will match. It get's even more complicated if I search two or more tables at a time.

If you have any suggestions on how i should go about this issue, please let me know.

[vaaaska]

This place is full with threads about how to go about doing this. In the "coding" forum at the top there is a stickied thread that has a link to a thread with ALOT of talk about these things.

Get something started and let us know how it's going...smooth out the messy bits.

[zzz]

These are great posts wiht plenty of good ideas. My problem is however is what do i do when I have search results pulled from more then one table?