Hi,

Im doing a search and it is just searching my html pages in my website, and displaying the results if the search matches any of the words in my search field.

The function will loop out when it reaches 10 results, and have a link to display the next results. It will pass that value of the last html page searched, and continue through that function when i click next.

I want to know how do i display the search results in this format with it listing all the pages ie: Pages (26): [1] 2 3 4 » ... Last »

Nevermind guys, i will try to store the search in a recordset and page it from there. Thanks.

Well, if you're pulling rows out of a database, you need two queries: one of them just counts the number of rows in the entire search. This lets you calculate how many pages of results there are. The second query just selects the subset of that result you need. Typically, you'll need a LIMIT and/or OFFSET clauses for this.

If you're just searching through text files in your filesystem, the approach should be the same -- it's much less efficient to store the results of an entire search in memory when you're only really going to work with a couple of them.


Take care,

Nik
http://www.bigaction.org/

Ok. Heres the situation. I am able to get rid of the html tags so that it would not search the html tags when I am using my text search approach.

The only problem that I am having now is that its not searching the content of my website, but its also searching the menus that I have on the side. Which means, it will pull up all the pages because there is a menu option on every page. FOr instance on the side panel i could have links to different pages on my website, and the side panel links would be on every page. SO the search results will not be unique and pull up all the pages up.

Is there anyway to solve this problem?