linking a displayed product to its position in a listing?

[tresseh]

I am trying to work out a way of linking a set product so that on clicking the product you are taken to its position within its category listing. This for example:

 

A 'featured' product is listed. The featured product is in a category called "category 2" and appears on the 3rd page of results. I would like it so that upon clicking that featured product, you are taken to that category listing (ie. default.php?cPath=8_2&page=3) and some sort of highlight. I can handle the highlighting easy enough :wink:, but can anyone help with how i can determine the url i need to link to?

 

Presumably i will need to determine the result pointer from the same query the product listing uses, equate this to the MAX_DISPLAY_SEARCH_RESULTS definition to find the page number im after, then somehow query the category the product is in?

 

As an extension to this, if i had say 10 or more of these kind of queries (asuming its even possible) would i experience a heavy server load because of the amount and complexity of queries?

 

The reason for this is that i dont actually need a 'product info' page for the types of products the store is selling, and i'm loathed to just have the link add the product to the cart, as i want to try to get customers impulse buying as much as possible.

 

Any help or suggestions would be great, and yes i know i like doing everything the hard way, but its fun ;)