Dispalying Database finds a few at a time?

I am using a python cgi to query a chemically aware database (daylight software) and for every query I am getting a large number of results. Obviously I would like it if I could display about 25 at a time. I can do this for the first 25, but then after that I don't know how to have a link to the next set of results without having to point to a new page. Is there anyway around this.

At the minute all the results are contained in a list called result_list.
The first 25 are;
printable_results = result_list[0:24]
and obviously this is called in the html by the %s symbol. I wondered if there was any way that a link in the html could change the value of %s to then display the next 25 results?

I'm not sure what you want to do. Do you want to show new results without loading a new page? Then you should fetch all results into a JS array, and I guess you could show 25 at a time using DHTML.
If you just want to get 25 results per page, just define something like &offset=34 in the URL to show results 34-59. Use this offset in your SQL with LIMIT offset, offset+25. Of course, this is all pseudo-code.