I'm taking my first shot at righting my own SQL-based directory/search engine. I'm having a bit of trouble with spanning search results. I need to get the total number of results vs. the number of results shown on the page. The problem is the only way I've been able to do this is to run the same query twice: once to get the number of rows matched, and once to get results for just the current page. Any ideas?

Happy coding,

--Drew
http://www.camelsoup.com
ftp://ftp.camelsoup.com