To clarify yes I do want a dropdown menu box, but the user would only be able to make one selection from it. I know I could store a different value in the actual text box and display something else but I'd like a confirmation page. The way I have it set up now is that the first script pulls up the form and the database fills in the options (like the quantity to add). Once the form is filled out, the script proceeds to a second one, which checks to make sure all of the fields have been filled out and displays a confirmation if everything is complete. After the "submit" button is pressed, it then goes on to the last stage where the information is submitted.
I'm just stuck right now trying to figure out how to fill out the values, and still have the value that is actually chosen to display in the second script. What I want to be able to do is show the user the information from the DB, but actually store the record number instead.
As an example, if the db looks like this:
Record Number: Quantity:
1 1/4
2 1/2
3 3/4
and the user chose 1/2 I actually want to store 2. Someone else helpfully suggested just querying the database at the confirmation page for matching records, but I'm not sure that's the best solution. I'm already querying the database once to populate the values so there must be another way to do this. The basic scripts I'm working with now are going to be the foundation for quite a few others so I want to make sure I have the most efficient solution. It might not make a difference now, but my thought is that a double query like this if it isn't necessary could crush the server under a very heavy load but then again this is the first project I'm tackling in PHP. 🙂 Help?
