Re: Random data loss.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2wsxdr5 wrote:
> With out posting any code I was wondering if anyone here has been
> experiencing this kind of problem.  I have a standard web from that PHP
> code then reads and saves the data into a MySQL DB.  The problem is some
> of my users have had data lost somewhere in this process.  The web site
> is www.thewishzone.com.  It is a wish list site and the data that seems
> to be getting lost is the price of an item a user adds to their wish
> list.  I can't seem to duplicate it here.  However one user did have it
> happen twice in a short time period.  They enter a valid price and after
> the record posts the price goes to zero.  Any ideas?

How do you determine a valid price?

Do you allow the $ to be in it?  Cuz MySQL sure won't take that.

Very common mistake.

Are you checking mysql result for error in your INSERT and UPDATE
statements.  MySQL should not be losing data without SOME kind of
message...

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux