Php question

[webtech]

Hi,

I am dedigning a online form and when they click submit it has to added to the database, before that I will have to get the notification from email and I have to approve it.

Whre do I have to store the data temprorly?

[michal]

Hi,

You can copy into another table, after you verify the data then copy into original table.

I guess this is the easy way to do it.

Good LUCK.

[Lippy]

Another method to do this is to have a field called "Confirmed" or something similar. This is either a 1 or 0. Then you could set a cron job up that every X amount of day/month/weeks all records set to 0 will be delete, while the ones that have a 1 will be untouched.

1=confirmed
0=unconfirmed

***Whoops, thanks for pointing out my #2 error***

[longplay]

Where'd the 2 come into it?

Anyway, this is the method I use for my newsletter script, simple enough to code and use and saves having two tables and the copying between.

[dmora]

Hi everybody.. i'm new in this forum... and i would like to have great experiences here.. sharing knowledge...

Well about this issue..... i agree with lippy.. but my only suggestion is to add another status... like pending.... bc if you set up a cron job to delete all those uncorfimed fields.... what would happen if you needed one of then...
so, the status table would look like this
0: confirmed
1: pending
3: denied.

The cron job will delete all denied rows....

hope it would be useful......