2. PHPRunner General questions
  3. Add Field deleted my records
This topic is locked

Add Field deleted my records

 		1/5/2007 6:19:16 PM
PHPRunner General questions
D
 dalimi author

I needed to add a field in one of my tables. After I did that PHPRunner notified me that it was going to delete my records. How can I go around this. I want to add a field without deleting records. When I created my table I forgot to add an important field "loan number". Please help.
T
 		thesofa 1/6/2007

I have had a similar problem before, it was down to where the field was added.

If you insert a field between 2 others, it can mess up the scripts.

If you add it at the end of the MYSQL table, you should be OK.

HTH
D
 		dalimi author 1/6/2007

I have had a similar problem before, it was down to where the field was added.

If you insert a field between 2 others, it can mess up the scripts.

If you add it at the end of the MYSQL table, you should be OK.

HTH


I tried adding a new field at the end, it didn't work. Any other suggestions?
J
 		Jane 1/8/2007

David,
to add new field without deleting all records modify your database in any administration database tool (for example, phpMyAdmin).