I recently built a shopping cart for selling books using PHP and MySQL, and have run into a strange problem. When customers view a product information page, a number of variables (title, ISBN, etc) are queried from a table and displayed on the page. If a customer opts to add the book to their cart, these variables are passed through a form (POST) to the next page, which inserts the variables in a second table representing the shopping cart. I've noticed, though, that about 10% of the time, at what appear to be random intervals, one certain variable gets dropped, and a blank is inserted in it's place. Other variables that get passed and inserted at the same time make it to the cart table flawlessly.. it's just this one "shelf_id" column. I haven't detected a pattern to the problem, and I can't seem to duplicate it myself (I just hear about it and see it happening in the table later).
It's a long shot, but does anyone have any similiar experiences? Is this a sign of a corrupt database, or just something I've overlooked? Any help is greatly appreciated.. it's been driving me crazy!
Thanks!
It's a long shot, but does anyone have any similiar experiences? Is this a sign of a corrupt database, or just something I've overlooked? Any help is greatly appreciated.. it's been driving me crazy!
Thanks!