External search engine, advice

I have an external search engine system which plugs in to postgres. I use a few
C functions to interface the search daemon with the Postgres back-end.

The best that I have been able to do is do a "select" for each result. I have a
live demo/test site:

http://www.mohawksoft.com/search.php3, and the PHP source code is at
http://www.mohawksoft.com/ftss_example.txt.

I would love to get the results with one select statement, but have, to date,
been unable to figure out how. Anyone with any ideas?