Products on the e-commerce website are specified as 'on special' with a database field that takes the values 'Y' or 'N'. On the search results page, those products with a 'on special' value of 'Y' should be flagged with a 'on special' image. The 'on special' image will be provided.
The database structure is already setup and 'on special' products have been assigned.