mysql insert error?

[oximo]

i have created table in mysql: +-----------------+------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+------------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | amount | decimal(10,2) unsigned | NO | | NULL | |


currently when user key in the amount. it's correctly insert to the table but got 1 case where when user keyed in amount 580, but the inserted value was 99999999.99 i'm not sure why this is happen. can any tell me how i have to debug my code regarding this matter. thank you

[Pggar]

Perhaps it would help if you gave us an indication of what you are using to insert your values? I'd pay particular attention in your table to the decimal(10,2) in your table when letting us know your reply. Add detail and I'll flesh out your answer.