inserting records and retrieving

theo

I wish to collect information from customers using a online form. I want the information to be stored in a database and sent to another page where the information will be displayed. Is there a way of doing both in one go.

I can store the information the customer has entered into the form in a database, however I need a way of retrieving the information to display on the following page. I could do it by retrieving the last record that was entered, however there might be a problem if 2 people entered the information at the same time.

Any ideas?

njm

theo,

In the script that processes the form fields and runs the INSERT query, just echo out the form variables.

hth, njm

theo

Thanks

But I am going to need to do calculations on the data. The only thing I can think to do is to collect all the data in the database including the IP address of the customer and then retrieve it on the following page based on the IP address.

Do you have any other ideas as to the best way to do this?

I am also having problems storing the IP in the database.

njm

It still seems a waste of time to me, to retrieve information from a form, INSERT this into a database, and then SELECT that data from the database out again to process. I assume this will all take place within a single session? Maybe post in a bit more detail exactly what you want to do - what sort of information is gathered, how it's to be stored, what sort of calculations, what to present back to the user etc.

hth, njm

theo

I am doing a quiz, where a user answers questions, and based on the sum of the results an answer will be given. eg. if the answers add up to 5 or less; an answer will be displayed on screen. If they add up to 10 or less then a different answer will be displayed etc. The answers need to be stores in a database as part of our data capture.

I hope this explains things better.

njm

OK,

So check if the form has been submitted, then insert the records into the database. Then do the calculations on the form variables, which will still be in scope, and echo them out to the screen.

hth, njm