I use dbmansql to organize the data of a shopping-card.
There are 4 tables. I table contains the items of the orders.
If someone ordered three items, there are 3 records in the orders table, identified by invoice-number.
Now I wanted to modify a record of such an order. When I search for the invoice-number I get the 3 records to choose which I want to modify.
I selected one record, made the changings, then I noticed that after that all 3 records was changed to the same values.
Any idea?
Michael
--
Michael Skaide
http://www.cycle24.de
There are 4 tables. I table contains the items of the orders.
If someone ordered three items, there are 3 records in the orders table, identified by invoice-number.
Now I wanted to modify a record of such an order. When I search for the invoice-number I get the 3 records to choose which I want to modify.
I selected one record, made the changings, then I noticed that after that all 3 records was changed to the same values.
Any idea?
Michael
--
Michael Skaide
http://www.cycle24.de