Auto fill in form using populated menus with php and mysql!
Posted on 2003-03-03
I just want to say first off that I am a new bie to php and mysql.
Here is my question: A breakdown of what I need to be able to do.
1: I have a php form, with a populated menu, that reads info from a table.
2: You pull the menu down, pick your Product lets says. And the product is then filled into the field below. This adds the price of the product.
3: Next to the field that as the new product select, there is a field that you put in a #. Example How many products? 1, or 2
5: Next with the amount put in, You have another menu that selects lets say the vender. and any other info into other fields.
5: With every thing selected and filled into the fields. I need to be able to create a Total amount, with options of a % mark up, add sales taxes, etc with the total amout due.
6: With all the info filled in, their is a next button that, when pressed takes all the info and places them into a nicly created invoice page. Once there the person has an option to send the invoice to a clients e-mail, they can select the clients e-mail from a drop down menu, and then sent a cc to themselfs.
7: All the info in the e-mail is sent in HTML formate, and also has the choose to save a copy as a PDF formate and then download it. Then they just print it out. All the info is also added to a table as well, to be edited or delected.