INSERT then SELECT Query = Record Locking Maybe??
Posted on 2006-04-01
I am trying to make my own Shopping Basket and I am stuck on something which has been annoying me for days now.
When I add my product to the ShoppingBasket table, the product appears within the table using PHPMyAdmin.
As my product description page then automatically redirects to the Basket View page, after inserting the record (as above) nothing shows up!!
But if I go back and add another item (with a different quantity to see the difference) it appears as though the lock on the first record is released and then is allowed to appear on the Basket View web page, but not the second record.
This continues for as many items that I have in there.
Does this make sense? How can I ...
1. Stop this from happening initially?
2. Remove lock almost instantly after the record is inserted?
Top marks available to the best and/or quickest answer that fixes the problem, as I'm running out of hair to rip out!!