How to use the same temporary table

[Anon]

Dear all,

I need to write a small program. There are several input fields on the web-page. After inputed these fields and press a button, another php update program is called to create a temporay table in MYSQL and insert the all information as a record into this temporary table. This update program will be closed automatically. When finished next inputs of the web-page. This information is saved a next record of the pervious temporary table with call php update program again. However, this updated program cannot reopen the pervious temporary table. How can I do?

The key point may be the way to connect to MYSQL server. I use mysql_pconnect to connect to MYSQL. It is because that the temporary table will be deleted automatically when the connection is dropped.

[[deleted]]

Don't use temporary tables to hold temporary data between http requests.
Instead store the data in a session or something and don't load the data into the database untill the data is complete.

[Anon]

Dear vincent,

Thanks for your suggestion.

The function of my program is to input some equal information of a group of members with same web-page.

All infromation of each member of a group is saved in MYSQL table until 'Update' button is pressed.

So I expected that it is a good way to use temporary table to save all records before
confirm to save them in real table.

May Cookie or suitable not suitable for my case? do you agree?

There is too few articles to memtion about this situation on book or on the web.