Product Order form with mysql database
Posted: Fri Jul 15, 2011 5:24 am
I have a Mysql database which holds all the product information (product code, description and price), this allows me to display the products on the site and keep them up to date from sage.
What I am trying to do is create a order form for customers to place orders, this does not need any form of payment as this is taken later. What i need help with is creating a form in which when a user starts to type a product code it will then bring up a drop down list searching for that product and allow the user to select the correct product, which then fills in the description and price from the mysql database.
The user would then need to be able to order multiple of the same item and do the same again for many products. Once all that the user wants has been selected a final price would need to be calculated.
If anyone knows of a script already about that I could modify or could help me to build this script I would be very grateful.
Thank you very much
What I am trying to do is create a order form for customers to place orders, this does not need any form of payment as this is taken later. What i need help with is creating a form in which when a user starts to type a product code it will then bring up a drop down list searching for that product and allow the user to select the correct product, which then fills in the description and price from the mysql database.
The user would then need to be able to order multiple of the same item and do the same again for many products. Once all that the user wants has been selected a final price would need to be calculated.
If anyone knows of a script already about that I could modify or could help me to build this script I would be very grateful.
Thank you very much