I've done something like this to remove 'dead' categories from my database searches and such.


For instance, links to 'amazon' could be excluded in your select statement with a:

URL NOT LIKE 'amazon'

I've actually done some pretty complext statements (over time) to exclude certain links, certain ranges, etc.

If the categories are in a 'tree' for instance, you don't want any categories in your 'books' are to show up, then use a select statement like used in the user.cgi/maintain.cgi where you select the range of category numbers, then check for a CategoryID IN (range)

I've lost track of what exactly you are still looking for, but excluding categories is not hard, nor is limiting URL's from searches, jumps and builds.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/