Wanting to perform a email order from product in database
Posted: Sun May 21, 2006 4:27 am
I am wanting to set up an HTML form that the user can enter quantities of the products they want to order. once they have entered the amounts the amount need to be check against the database that there is sufficent stock and then deduct that from stock and email to the company the order.
the form is currently dynamically created with the list of fields from the database being
Name, Price, Unit, Available. these fields are displayed in table rows. I had added a text field called Order on the end of each row with the name of the field being the name of the product stored in the Name field.
When I post the order from this page I need to be able to collect the list of product that have had quanities entered and then display the list with a confirm order.
Once the user clicks confirm the next step is to deduct the product from the database (if someone else has ordered product and there is no longer enough stock they need to be taken back to the order form with the current stock level shown and there original order in the field so they can adjust it.) and generate an email to be sent to the company showing the order being sent through. the order will be identified by a client number used to log in.
could someone please give me some Ideas on how to do this process
the form is currently dynamically created with the list of fields from the database being
Name, Price, Unit, Available. these fields are displayed in table rows. I had added a text field called Order on the end of each row with the name of the field being the name of the product stored in the Name field.
When I post the order from this page I need to be able to collect the list of product that have had quanities entered and then display the list with a confirm order.
Once the user clicks confirm the next step is to deduct the product from the database (if someone else has ordered product and there is no longer enough stock they need to be taken back to the order form with the current stock level shown and there original order in the field so they can adjust it.) and generate an email to be sent to the company showing the order being sent through. the order will be identified by a client number used to log in.
could someone please give me some Ideas on how to do this process
