Compare Database Records to Image File Names

The idea is fairly simple. I have a database which contains products for an online store and each item is given a unique product id. To simplify things, each product image is named after the product id - example: [login to view URL] Now what I need to do, is make a list of images that DO NOT match a record in the database. In this case, the product was discontinued, and deleted from the database, but the image remains. The script should esentially compare the image names to the record ids and output a list of images that do not match any records. This should be a simple task for the right coder - the script is something along the lines of SELECT WHERE NOT productID = imagename [login to view URL] "filename" Make sense? ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform Active Server Pages