ok, am struggling to explain it......
righy, the source page has a list of links which list out categories from a recordset (eg domain.co.uk/type/monthly-disposable where the last part is generated by the CatPermalink column in the productcategories table
When you click on the link, you get taken through to a page which, at the moment, lists all products. However, I want to filter the product results based on the category that is used in the URL (in the example the column CatPermalink - in my example monthly-disposable, but it could be another such as daily-disposable, its entirely dependent on whats in the tabel.
On the page I attached in my first post, the products are being listed by recordset 'Products' but I dont know how to then filter the results based on the URL monthly-disposable (or whatever has been created in the URL on the source page witht the CatPermalink column from the productcategories table.
Hope that perhaps explains a bit better ? :S