Re: when to enter submitted in mysql?

Personally, I'd keep it all in the session and write at the end, but this approach has at least two drawbacks: 1. The user cannot complete the process at a later point. 2. You cannot conduct analysis of part-completed data. Cheers, David Grant afan@afan.net wrote: > Hi to all! > I have form made on 4 pages (by groups of questions). Right now my code > works this way: once somebody submit the first page of the form his/her > submitted info is entered in database with status=temp. I store the ID > (insert_id()) in session and then every time visitor submit the next > page I do update of the current record using ID. > But, I heard once that "the best" solution is store all entered info in > session (array) and insert all info at once. > Or, instead in sessions, move submitted info with serialized array. > > Opinions? > > Thanks for help. > > -afan > -- David Grant http://www.grant.org.uk/