Hello All!! I;m just starting out at this wonderfull worl PHP. I need some help from you all. I have managed to get the phpformgenerator working perfectly and have customized the form in html but there are a couple of thing else that i want to do but dont know where to get the info. I have made a form for my business so my sales staff can send me a request for a special order for a customer. With this i have being able to do just 1 row per customer request but sometimes i will need more than one product to be introduced for teh same customer, how can i add this to the database?
Also does anyone know a good scrip like this for making querys?
Thanks to all in advance
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
your explanation isn't very clear. You should be able to enter as many fields as you like, and the program will add as many fields to the database as you have on your form. What exactly is the problem you are facing? If you are using a drop down select menu for your product list, you can have more than one of those. For example, you can make 5 of them, Product 1, Product 2, Product 3, Product 4 and Product 5. These can be drop down selection menus with your list of products PLUS a blank field that reads something like "none". So now the sales staff can add up to 5 products. Ofcourse you can have more than 5, you should choose a maximum number to be on the safe side.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2003-09-10
Musawir, thanks for your replay. Let me trie to explain a little more. The form is used so my staf can send me requests on special order productos for teh customers. Lets says i have the following fields: Part # , Description, Price and all of them are text input. Let says a salesperson enter 1 item to order, that info will go to the first row in the table. But my problem is what happends when he inputs more than 1 item to order. The form allready has the inputs spaces for up to 10 item but when you put more than one it wont intriduce them in the table.
So when i do a query it will show me the complete list of items in each request.
I hope this clear up a little
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello All!! I;m just starting out at this wonderfull worl PHP. I need some help from you all. I have managed to get the phpformgenerator working perfectly and have customized the form in html but there are a couple of thing else that i want to do but dont know where to get the info. I have made a form for my business so my sales staff can send me a request for a special order for a customer. With this i have being able to do just 1 row per customer request but sometimes i will need more than one product to be introduced for teh same customer, how can i add this to the database?
Also does anyone know a good scrip like this for making querys?
Thanks to all in advance
your explanation isn't very clear. You should be able to enter as many fields as you like, and the program will add as many fields to the database as you have on your form. What exactly is the problem you are facing? If you are using a drop down select menu for your product list, you can have more than one of those. For example, you can make 5 of them, Product 1, Product 2, Product 3, Product 4 and Product 5. These can be drop down selection menus with your list of products PLUS a blank field that reads something like "none". So now the sales staff can add up to 5 products. Ofcourse you can have more than 5, you should choose a maximum number to be on the safe side.
Musawir, thanks for your replay. Let me trie to explain a little more. The form is used so my staf can send me requests on special order productos for teh customers. Lets says i have the following fields: Part # , Description, Price and all of them are text input. Let says a salesperson enter 1 item to order, that info will go to the first row in the table. But my problem is what happends when he inputs more than 1 item to order. The form allready has the inputs spaces for up to 10 item but when you put more than one it wont intriduce them in the table.
So when i do a query it will show me the complete list of items in each request.
I hope this clear up a little
Thanks