Price Is Reduced After Specified Days

I want the prices of my online store products reduced to specified amount on the basis of when the product was created. When a new product is submitted, the discountprice field in the products table receives a default value based on the price (price * .94 = discountprice)

PRODUCTS database fields (involved in this project)
discountprice price * discountrate = discountprice
discountrate .94 (default)
discountdays 10 (default)
datecreated 2010-11-08 23:34:28 CURRENT_TIMESTAMP (default)

Change the SQL Statement in the products pages to include an "IF" statement.
EXAMPLE: If datecreated AND discountdays = OR < NOW then show discountprice OTHERWISE price

PAGES THAT REQUIRE THE CHANGE: I will provide the following PHP pages for the freelancer to change. If its not hard, I may add the additional SQL to complete this project.

SCENARIO: On a default situation, if I created a product called XYZ with a price of $100 on 2010-11-08 23:34:28, then on 2010-11-18 23:34:28, the price would display $94. Only if I changed the discountrate, would the price of this product vary. Only if I changed the discountdays, would the price change on a different day.

Scripting Language/Database: PHP MySQL

Send me a private message regarding your approach to making this work and the results of the work in completing this project.

Above, I have provided what I believe is all the information regarding this project. Please base your bid on this but I will be happy to answer questions and exchange correspondence through this websites personal message board during the development of this work. Try to keep in mind of time zones differences if responses arent immediate.

Tags: , , , , , , , , , , , , , , , ,