Sports

September 28, 2008

How to overwrite / update a previous record automatically in mySQL?

mysql
hockey_goalie31 asked:


I have a mysql database that receives the data from a php form that submits a unique user id, and 3 sports. I will likely be adding new fields (age etc) but the main thing I want to accomplish is if my users go through the form again (logged into to the same user id) and submit different information, how could I overwrite the old entry so I only have 1 record for the user?

hopefully this is possible one way or another !

Filed under Programming & Design by administrator

Permalink Print 2 Comments