MySQL overwriting entries in database
Im having some trouble with a MySQL database that I've been using with an online application form i developed a few weeks back. I thought I had finished the form as i didn't have any errors until we have come to test it over the past few days. The problem is When 2 different users use the form, or the same user closes the browser and starts a new session, the newest data will overwrite all other data in each field across all tables. Also if one person is filling out the form and a second users then starts a few moments after, the first person is then referred to the beginning when they move forward a page as the data base has lost all previous information.
you can see the form at www.moorpark.lancs.sch.uk/teachapp/
the pages go as follows with each step page running an included 'process' page
if needed i can sort out some paste bins of the full page code.
I have just noticed i have missed a 'where' statment off the end of my sql syntax.