I am in the process of changing my website www.collectcamera.com into a database driven website. The last step in the process gives problems. I found a shopping cart program that could work fine. However, the function SESSION doesn’t seem to work properly.
If I place an article into the shopping basket, the article will be written into the table “s_wagentje”, where the field “wagentjeID” should give a unique number. The problem is that it always writes to number one. This means that everyone can see what somebody else put in the shopping cart.
As soon as the order is placed, the table “wagentjeID will become empty and the tables “s_bestellingen” and “s-bst_details” will be filled. The order will be written into these two tables with a unique number in the field “bstID” . So, this part of the program works fine.
I tried a few alternative shopping cart programs with the same negative result. The items are all written to the same itemID. I use the function SESSION in another application where it works fine.
I changed the field “wagentjeID” from the table “wagentje” into auto-increment. Result was that the program did not work anymore.
I would be very grateful if someone could help this desparate amature.