Search Page

I'm making a search page on my site where users enter certain criteria and I ouput the results like many other webistes: By first telling how many results were generated, then having dynamic pages to view, say, 10 results at a time. So first I have to SQL the database to get totalresults, then cancel that query and query again with a "LIMIT" tag on the end to display the first 10 results. Is there a more efficient way of doing what I'm trying to do? I coded it myself so its probably poor, design-wise. Am I going about it the right way? -- Regards, Georgie Casey webmaster@filmfind.tv *************************** http://www.filmfind.tv Ireland's Online Film Production Directory ***************************