Coolguymnit Private Project

Our website needs a Make An Offer System 1) Add a button called "Make An Offer" on this page [login to view URL] sample see [login to view URL] 2) AFter this button is pressed it will display a text box for a price they are offering and a box for their email address sample see [login to view URL] 3) after they enter the information and hit submit it will display a message "Thanks for your offer. We will review it and email you with our answer" it will write their offer into a table below with a distinct hash key create table offerMaster ( offerKey varchar2(20) primary key, offerTime datetime not null, email text not null, item_no int not null int, offerPrice decimal(20,2) not null, accepted int(1) default 0 ); 4) next i need a jsp to view the offers next to each offer there will be an accept button and re-offer button the accept button will set accepted=1 in the table and email the customer an email We have accepted your offer. please click here to <a href="[login to view URL][offerKey]">Checkout</a> the re-offer button will ask for price and create a new entry into offerMaster with the same info but a different price and set accepted to 1 then send the email We cannot accept $oldprice but we will accept this price $newprice. If you would like to accept this price checkout here <a href="[login to view URL][new offerKey]">Checkout</a>